I have a set of data like so:

1 9|3|5|4
2 7|6|6|6
3 3|6|2|7
4 6|9|4|7

And I would like to auto-format the highest value in each row. So, for instance in row 1, A1 would get the auto-format, row 2: A2, row 3: D3, row 4: B4. I have been playing with auto format using =percentrank(), but cannot get the hang of it.


Ideal case for Conditional Formatting (Format - Conditional formatting....), having selected A1:D4:

Choose Custom formula is (only available in new Google Sheets),
Enter there:


Select your formatting, Save rules.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.