Dynamic Thresholds for Conditional Formats
First Claim
Patent Images
1. 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.
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
20 Claims
-
1. 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. 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. - View Dependent Claims (11, 12, 13, 14, 15)
-
-
16. 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. - View Dependent Claims (17, 18, 19, 20)
-
Specification