Dynamic Thresholds for Conditional Formats
AssigneeMicrosoft Corporation
InventorsBenjamin C. Chamberlain, Bruce Cordell Jones, Christopher M. Street, Eric B. Vigesaa
Life of this patent
Estimating the term…
Abstract
Generally described, embodiments of the present invention provide the ability to utilize dynamic thresholds and dynamic threshold values when generating variable formatting rules to be applied to a range of cells. Dynamic thresholds include, but are not limited to, “Highest Value,” “Middle Value,” “Lowest Value,” “Number,” “Percent,” “Percentile,” and “Formula.” When using a dynamic threshold, dynamic threshold values are determined based on values contained in a selected range of cells.
Claims20
A computer-readable storage medium having computer executable components for determining dynamic threshold values for variable formatting a range of cells, comprising:
- a variable format command component maintaining an icon variable format for application to the range of cells, the icon variable format applied to at least one cell in the ranges of cells being dynamically determined;
- a threshold type component identifying a threshold type that utilizes a dynamic threshold value;
- and
- a dynamic threshold value component for determining a value for use as a dynamic threshold value, wherein the value is determined from values contained in a plurality of cells.
A method implemented on a computer-readable storage medium for formatting a range of cells using variable formats, the method comprising:
- defining an icon variable format to be applied to a range of cells, wherein the icon variable format includes two or more threshold points, each of the two or more threshold points having a threshold type;
- and
- determining a dynamic threshold value as a value for each of the two or more threshold points.
A method implemented on a computer-readable storage medium for formatting a range of cells using variable formats, the method comprising:
- defining a data bar variable format to be applied to a range of cells, wherein the data bar variable format includes a threshold point having a threshold type;
- and
- determining a dynamic threshold value as a value for the threshold type.
Dependencies are inferred from the claim text.