Using conditional formatting for highlighting the highest value
On the following example table, let’s highlight the highest weekly allowance with green color:
1. Start by selecting the relevant range.
2. Click the “Conditional Formatting” button, and choose “Top/Bottom Rules”, then choose “Top 10 Items”.
2. Click the “Conditional Formatting” button, and choose “Top/Bottom Rules”, then choose “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.
4. Click OK.
5. Done! you can see the highest value (25) is highlighted with green.
