Conditional Formatting for Column?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there an easy way to format 1 or 2 cells in a range? For example, I have
4 cells

A1 25
A2 30
A3 35
A4 25

I want to highlight the lowest cell number of the column in RED (if there
are two, I want to highlight both of them.

Any help is welcome. Thanks.

G
 
Try making the condition for the format =MIN($a$1:$a$4). The $s may or may
not be a good idea. They have the usual effect of freezing or freeing
references as you copy the format.
 
Jim/Ian,

Thanks, very helpful. One follow-up question ... would it be possible to
highlight the 2nd Lowest total? If so, how would I do that?

Thanks.

G
 
Thanks, Ian, but this appears to get ONLY the two lowest. In the case of the
sample data (below), I only highlight the two 25s. I would like to highlight
the two 25s AND the 30. Any ideas?

Thanks.

G
 
Set 2 conditions. You can set up to 3 for each cell. If the 1st isn't
satisfied, it moves on to the second etc
 
Back
Top