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.

Highlighting in Numbers

I want to simply highlight the highest/maximum value in my selected cells. In Excel, it's a snap. Numbers takes the rules and sticks its tongue out doing precisely nothing.


I followed the 2020 suggestion creating a calculation for the maximum, setting the value and the formatting. Nothing highlights,

iMac 24″, macOS 13.0

Posted on Nov 27, 2022 12:56 PM

Reply
Question marked as Top-ranking reply

Posted on Nov 27, 2022 2:12 PM

It is not as comfortable as in Excel, but it can be done.

But Numbers is free, as long as you own an Apple device, for Excel you have to pay.


Here an example for min & max for column A

It is important that you preserve the row & column for $B$2 and $C$2


Hope this will solve your question, please let me know if this worked for you or if something in unclear.


Regards Ralf

Similar questions

2 replies
Question marked as Top-ranking reply

Nov 27, 2022 2:12 PM in response to helpless111

It is not as comfortable as in Excel, but it can be done.

But Numbers is free, as long as you own an Apple device, for Excel you have to pay.


Here an example for min & max for column A

It is important that you preserve the row & column for $B$2 and $C$2


Hope this will solve your question, please let me know if this worked for you or if something in unclear.


Regards Ralf

Highlighting in Numbers

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