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