Apple Intelligence is now available on iPhone, iPad, and Mac!

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Conditional highlighting to find a Max or Min value

Hi all, I'm trying to figure out how to highlight a Max value in a column. What I've read so far is helpful but it seems like you need to know the Max value to then set the rule to highlight it through conditional highlighting. Or, reference a header or footer cell with a value to then find the max value. However, I want Numbers to find the highest value for me (there are hundreds of rows...) and highlight it, without having to reference. It seems easy on Excel but am having trouble to find out how to do it on Numbers.

Posted on Sep 16, 2022 7:30 AM

Reply
Question marked as Top-ranking reply

Posted on Sep 16, 2022 7:55 AM

You can do something like this simple example:




Row 8 is defined as a Footer Row. The formula in A8 is =MAX(A)


In general, as I think you have discovered, Conditional Highlighting works by comparing the value in the cell to something, in this case to the Max value in A8.


For Min, you would do similar except use the MIN function.


SG

1 reply
Question marked as Top-ranking reply

Sep 16, 2022 7:55 AM in response to fritzfrompr

You can do something like this simple example:




Row 8 is defined as a Footer Row. The formula in A8 is =MAX(A)


In general, as I think you have discovered, Conditional Highlighting works by comparing the value in the cell to something, in this case to the Max value in A8.


For Min, you would do similar except use the MIN function.


SG

Conditional highlighting to find a Max or Min value

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