Excel Conditional Formatting Data Bars, Color Scales and Icon Sets
Related Pages:
Conditional Formatting Highlight Cells RulesConditional Formatting Top/Bottom Rules
Conditional Formatting Using Formulas
The Excel Conditional Formatting Data Bars, Color Scales and Icon Sets allow you to apply formatting to all cells in a range, depending on their value in relation to one another.
Note that these options are only applied to cells containing numeric values.
The Data Bars, Color Scales and Icon Sets conditional formatting options are listed in the Excel Conditional Formatting menu, which is generally located in the 'Styles' group of the Home tab on the Excel ribbon (see below).
In order to apply one of these options to a range of cells, simply select the range of cells to be formatted and then select one of the pre-defined formatting styles from the menu.
The above table on the left shows examples of Data Bars, Color Scales and Icon Sets applied to the values 1 - 10 in a range of spreadsheet cells.
It is shown that, in addition to highlighting patterns in data, these options can give your spreadsheet a smart and professional look.