Conditional Highlighting

[Winehouse]

Hi

I’d like to highlight the highest & lowest numbers in a column.

I’m using Numbers for iPhone & although I can see examples of how to do it in Excel, I can’t see how to do it in Numbers.

Thank you for any help.

Regards

 

[Peter_SSs]

As I understand it, this can be done in Numbers on a Mac and it will carry over to the iPhone but it can't be initially set up on the phone.
Happy to be proved wrong though.

 

[Winehouse]

Thanks.

I’ve just made a workaround.

Smallest number is most important, so I made a new row & put the smallest numbers in using the SMALL function, then I can use the Equal to rule to highlight the lowest number.

Works well.

Regards

 

[Peter_SSs]

Glad you found a solution. Thanks for letting us know.