Conditional Formatting for Column?
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.
"G" wrote:
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
|