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.

  1. 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.

  2. 0

    Mike Lipay

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Thanks, Ian.