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

Click on A3

Format, Conditional formatting, Formula is: '=A3 = MIN($A$3:$D$3)'
{without the single quotes)
Select your formatting options, OK

Copy cell A3
Paste special, formats over the rest of the range.

HTH
Steve

"Joe Gieder" wrote in message
...
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

or even select A3:D3, do the CF stuff, and save the copy paste afterwards.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Steve" wrote in message
...
Click on A3

Format, Conditional formatting, Formula is: '=A3 = MIN($A$3:$D$3)'
{without the single quotes)
Select your formatting options, OK

Copy cell A3
Paste special, formats over the rest of the range.

HTH
Steve

"Joe Gieder" wrote in message
...
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

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

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
.

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
.

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
.

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

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