| Applying Conditional Formatting Conditional formatting is a feature that enables users to apply formatting to cells automatically depending on the value of the cell or the value of a formula. By visualizing data in a graphical way, you can identify trends and exceptions more quickly.
To visualize the value of a cell relative to other cells in the same range: 1. Select a range of cells. 2. On the Home tab, in the Style group, click Conditional Formatting, click Data Bars, and then select a data bar icon.
To classify data into three to five categories separated by a threshold value, use icon sets: 1. Select a range of cells. 2. On the Home tab, in the Style group, click Conditional Formatting, click Icon Set, and then select an icon set.
|