Select the top row, do formatconditional formatting,
formula is and use

=A2=SMALL($A$2:$D$2,COUNTIF($A$2:$D$2,0)+1)

click the format button and select either pattern or font
and change the colour. Copy using format painter to the rest of the cells

Adapt to fit your own cell ranges


--


Regards,


Peo Sjoblom





"Marie" wrote in message
...
I have 4 adjacent columns of values. For each row, I need to highlight the
lowest value, ignoring any blank or 0 value cells in that row. There are
about 1200 rows.......so I need this to repeat to the end of the rows.

Any takers?

As always, thanks in advance for your kind help and input.