Excel + Google Sheets · Highlight the top

Make the top value glow

A rule that colors the row with the highest number, even when data changes.

The formula

=$B2=MAX($B$2:$B$6)

What each part means

$B2This row's value
MAX($B$2:$B$6)The highest of all

Example

Home → Conditional formatting → New rule → Use a formula

Before

	A	B
1	Rep	Sales
2	Laura	1,250
3	João	980
4	Priya	2,410
5	Tom	640
6	Ana	1,730

After

	A	B
1	Rep	Sales
2	Laura	1,250
3	João	980
4	Priya	2,410
5	Tom	640
6	Ana	1,730

Step by step

Select the data, from row 2 down.
Go to Home → Conditional formatting → New rule → Use a formula.
Paste the formula: =$B2=MAX($B$2:$B$6)
Click Format, pick a fill colour and press OK.

In Google Sheets: Format → Conditional formatting → Custom formula is.

Where it works

Every version of Excel
Google Sheets
Excel for the web (free)

The same formula in other languages

Get 1 formula a day, free

Plus a free weekly planner template for Excel and Google Sheets. Unsubscribe in 1 click.

✓ Done! Check your inbox to confirm.

Want ready-made templates? See the Formulyo pack →

Keep learning

Conditional formattingMake late tasks turn red Find duplicatesSpot duplicates instantly Highlight weekendsMake weekends pop out Below targetSpot who's below target WORKDAYGet the deadline in working days &Join cells with one symbol