How to Apply Conditional Formatting in MS Excel

Applying Conditional Formatting in MS Excel
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.