conditional formatting

[Guest]

I have the following values in cells c1:f1:

C D E F
1 32 n/a 38 34

I would like to set up a conditional format to shade the lowest value cell
from c1:f1 but it must ignore the cell with value "n/a". I tried highlighting
the cells c1:f1 and in conditional formatting I set up "cell value equals ...
min(c1:f1) and formatted cell pattern to red however nothing happens. I
appreciate help with this.

Thanks.

 

[Jason Morin]

Select "Formula Is" and use:

=C$1=MIN($C$1:$F$1)

HTH
Jason
Atlanta, GA