conditional formatting
 

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

Select "Formula Is" and use:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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.
--
Shooter
.