How can I highlight the highest value in each row of a table?
M

1

5

In Google Sheets, I would like to highlight the max value in each row of a table.

I tried using conditional formatting, but without any success so far.

Mispronounce answered 18/8, 2019 at 14:11 Comment(0)
D
8

custom formula is:

=(A1=MAX($A1:$D1))*(A1<>"")

0


for columns:

=(A1=MAX(A$1:A))*(A1<>"")

enter image description here

Donatello answered 18/8, 2019 at 15:12 Comment(2)
This is awesome! What would be the syntax for highlighting the max number in each column instead of each row?Monzon
@CruzNunez answer updatedDonatello

© 2022 - 2025 — McMap. All rights reserved.