This works for me:

Click in BN3, and start the conditional format.

Formula Is:
=BN3=MIN($BN$3,$BK$3,$BQ$3,$BT$3,$BW$3)

Then, set your format, and <OK out.

Now, with BN3 still selected, *double click* on the "Format Painter" icon
(yellow paint brush), and navigate to, and click on, each of the cells in
the formula.
Then hit <Esc.

And you're done!
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Joe Gieder" wrote in message
...
Biff,
The formula I need is something like this since the values I'm evaluating
aren't side by side, they're every 3 columns.
=$BN3=MIN(IF(OR($BK3,$BN3,$BQ3,$BT3,$BW3)0,OR($BK 3,$BN3,$BQ3,$BT3,$BW3)))
My example does show them side by side but I didn't plan on running into
zeros.
Can this be done. with the formula like above it doesn't highlight anything.
Sorry for the wrong example.
Joe


"Biff" wrote:

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
.