Excel Tips – How to Automatically highlight maximum and minimum values?

Excel Tips – How to Automatically highlight maximum and minimum values in a list?

Conditional Formatting – Top/Bottom Rules

1. Select the Range.

2. On the [Home] tab click [Conditional Formatting] à Top/Bottom Rules à Top 10 items….

3. In the Top 10 items dialogue box specify the number of top items that you wish to highlight and the format for the same. Click <OK>

4. To highlight bottom values, on the [Home] tab click [Conditional Formatting] à Top/Bottom Rules à Bottom 10 items…

5. In the Bottom 10 items dialogue box specify the number of bottom items that you wish to highlight and the format for the same. Click <OK>