Hmmmm, That's a bit more complex.

You need a minimum if statement. Excel doesn't provide one. So you'll need
to enter an array formula in a spare cell:

Copy the following to A1 (or somewhere else)

=MIN(IF(A3:D3 0,A3:D3,"")) in a spare cell

Press Ctrl/Shift/Enter to enter the formula

Highlight A3: D3

Format, Conditional format,
Cell value is, equal to, enter '$A$1' (or your other cell reference) in
the third textbox

Click OK

Steve

"Joe Gieder" wrote in message
...
Thank you. It works great until I ran into one problem, when 0 is in the
equation it wont highlight anything. Is there a way to make it highlight
greater than zero?

TIA Again
Joe

"Joe Gieder" wrote:

I'm trying to highlight the cell with the lowest value by using
Conditional
Format.
Example..
A3 = 4
b3 = 7
c3 = 3
d3 = 10
I want to highlight C3 but I tried
=MIN(K$3,$BN$3,$BQ$3,$BT$3) in the Formula Is part of Conditional
Formating
and it highlights all the values. Can This be done.

TIA Again
Joe