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
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
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
Provide a screenshot of what you have (showing table, formula, and highlighting rule) so we can more easily help you get the result you want. Or we can post a generic example, but it sounds like you already followed one of those and it didn't work out.
Highlighting in Numbers
