View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Skrydlak Jim Skrydlak is offline
external usenet poster
 
Posts: 23
Default 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