Benches / Uncategorized
2
Conditional highlighting question
apple Verified ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
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.
2 replies
Sign in or join Beachball Help to reply.
0
Yellowbox ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
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.
0
Mike Lipay ·
Imported from the Apple Support Forums via the Wayback Machine 🔗