Patent ID: 8914717

Claim:
A method for determining dynamic threshold values for variable formatting a range of cells, comprising: determining a range of cells; determining a format style, wherein the format style is one of an icon set; data bars; or a color scale; determining a first threshold type, wherein the first threshold type is one of a value; a percent; a percentile; a number; or a formula; determining a second threshold type, wherein the second threshold type is one of a value; a percent; a percentile; a number; or a formula; evaluating the content of all of the cells in the range of cells to determine a first dynamic threshold value that is within the range of cells based on the first threshold type and a first threshold point; and evaluating the content of all of the cells in the range of cells to determine a second dynamic threshold value that is within the range of cells based on the second threshold type and a second threshold point; evaluating the content of all the cells in the range of cells to determine a format value for each cell in the range of cells; and comparing the format value of each cell in the range of cells to the determined first dynamic threshold value and the determined second dynamic threshold value; and applying the format style to each cell in the range of cells based on the comparison between the format value of each cell in the range of cells and the determined first dynamic threshold value and the determined second dynamic threshold value such that the format style of each cell in the range of cells varies according to the format value of the cell in relation to the determined first dynamic threshold value and the determined second dynamic threshold value.