Follow Us :

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>

Tags:

Join Taxguru’s Network for Latest updates on Income Tax, GST, Company Law, Corporate Laws and other related subjects.

0 Comments

Leave a Comment

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

Search Post by Date
June 2024
M T W T F S S
 12
3456789
10111213141516
17181920212223
24252627282930