I answered your question yesterday. See:

http://tinyurl.com/4f637

HTH
Jason
Atlanta, GA

>-----Original Message-----
>I am still struggling with this one:
>
>I have values in cells c1,d1,e1,f1,g1
>I would like to shade the cell with the lowest value.
One or more of the
>cells may be blank or have n/a which should be ignored.
>
>I have tried highlighting the cells together and in
conditional formatting I
>set "formula is" =min(c1:g1) then I select the pattern
color. This is not
>working. I appreciate any suggestions.
>--
>Shooter
>.
>