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

Conditional highlighting question

This doesn't seem to be an option, but does anyone have a way for it to work?


I have a row of several numbers, I would like to highlight the cell that has the lowest value in the row.

MacBook Pro 13", 10.13

Posted on Jan 28, 2019 4:10 PM

Reply
Question marked as Best answer

Hi Mike,



Formula in Header cell A2 =MIN(2:2)

Fill down.


Select all the body cells and insert the conditional highlighting rule.

Equal to A2 will automatically fill down for other rows.


Regards,

Ian.

Posted on Jan 28, 2019 5:31 PM

2 replies

Conditional highlighting question

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