Hi!

That can be shortened to: (and it's not such a hack after
all!)

=BK3=MIN(IF(MOD(COLUMN($BK$3:$BW$3),3)=0,IF
($BK$3:$BW$30,$BK$3:$BW$3)))

Biff

-----Original Message-----
Hi!

This is a real hack but it works:

Formula is:

=BK3=MIN(IF(MOD(COLUMN($BK$3:$BW$3)-COLUMN(OFFSET
($BK$3:$BW$3,,,1,1)),3)=0,IF($BK$3:$BW$30,$BK$3: $BW$3)))

You'll have to enter the cf in each cell individually. In
other words, you can not select cells BK3,BN3,BQ3,BT3 and
BW3 as a range and then enter the cf and expect the cell
references to automatically adjust.

You CAN enter the cf in one cell then CopyPaste
SpecialFormats to the other cells.

Biff

-----Original Message-----
That was the first attempt I made and it works except
that it selects zero
when it's the lowest. I'm trying to get this to work by
ignoring or using
greater than zero values and selecting the lowest value.
Sometimes all cells
have values and it works fine, it's the zeros that foul
things up.

TIA
Joe

"RagDyer" wrote:

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
news:65097F9C-B752-4E63-9587-
...
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
($BK3,$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
.




.

.