Patent ID: 7770100

Claim:
A computer-readable storage medium having computer executable components for determining dynamic threshold values for variable formatting a range of cells within a spreadsheet, comprising: a variable format command component maintaining a variable format for application to the range of cells, the format applied to at least one cell in the range of cells being dynamically determined; a threshold type component identifying a threshold type that utilizes a dynamic threshold value; a dynamic threshold value component for determining a value for use as the dynamic threshold value; wherein the value is determined from values contained in a plurality of cells, and wherein the plurality of cells is different than the range of cells; wherein the variable format command component dynamically determines the variable format for the at least one cell in the range of cells based upon the threshold type and the determined threshold value; and wherein the threshold type is a lowest value, a highest value, a middle value, a percent, a percentile, or a function.