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>

More Under Finance

Posted Under

Category : Finance (3456)
Type : Articles (14349)
Tags : Excel Tips (35)

0 responses to “Excel Tips – How to Automatically highlight maximum and minimum values?”

  1. PANKAJ says:

    THANK YOU VERY MUCH

  2. Sivaram says:

    Thanks. It is a useful tips and working well.

Leave a Reply

Your email address will not be published. Required fields are marked *