Back to Conditional Formatting Menu

Using conditional formatting for highlighting the highest value


On the following example table, let’s highlight the highest weekly allowance with green color:

A table for applying the highest number conditional formatting for it

1. Start by selecting the relevant range.

2. Click the “Conditional Formatting” button, and choose “Top/Bottom Rules”, then choose “Top 10 Items”.

Opening the menu for Top/Bottom rules and top 10 items

3. Change the “10” into “1” (because we want only the one highest value to be highlighted), and choose the green color.

Dialog box after choosing 1 highest item and green color

4. Click OK.

5. Done! you can see the highest value (25) is highlighted with green.

A table after the highest value conditiona formatting has been applied