Hi!

If 0 was the lowest value it should have highlighted that.

Formula is:

=A3=MIN(IF($A$3:$D$30,$A$3:$D$3))

Biff

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