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
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
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.
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.
Thanks, Ian.
Conditional highlighting question