CODEWITHSUNDEEP
google-sheetsgs-conditional-formattinggoogle-sheets-formula
Matt Malloy
Matt Malloy

Reputation: 13

Conditionally formatting greatest value in range

I want to have the greatest value in a row be colored. I know I can do it with conditional formatting I'm just not sure what the custom rule should be.

I have data points in row 8 of columns C-G, the data points change every day as teams earn more points.

I've tried:

=C8 < D8 < E8 < F8 < G8

that didn't work.

Any suggestions?

Upvotes: 1

Views: 2308

Answers (1)

pnuts
pnuts

Reputation: 59475

Please select C8:G8, Format, Conditional formatting..., Custom formula is: 

=C8=max($C8:$G8)

choose your formatting and Save rules.

Upvotes: 1

Related Questions