select all the cells, and apply CF with a formula of

=C1=MIN(IF($C$1:$G$1>0,$C$1:$G$1))

and set pattern as required

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Shooter" <Shooter@discussions.microsoft.com> wrote in message
news:9C374FAB-8444-41AE-9050-E5A9701B1394@microsoft.com...
> 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