Highlighting max value?

I have a column of numbers and would like to conditionally highlight the max value. I know how to create a conditional format but how do I use MAX() in it?

Posted on Sep 3, 2015 10:04 AM

Reply
Question marked as ⚠️ Top-ranking reply

Posted on Sep 3, 2015 3:34 PM

Hi 4thSpace,


A table with a Header Row and a Footer Row.

Formula in B8 =MAX(B)

User uploaded file

User uploaded file


Regards,

Ian.

1 reply
Sort By: 

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Highlighting max value?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.