Change formatting for lowest value in a range 2

[BlueHorizon]

Hi all,
Using Excel XP, how can I change the formatting for the lowest number in a range of cells? Example:

A1 A2 A3
2.3 2.4 2.5

I need something that will identify the lowest value (2.3) in this range of cells and change the formatting of the value in that cell to be bold and red.

Thanks so much for your help and all the help you give everyone!


Best,
Blue Horizon

http://www.bluehorizontraining.com

 

[GlennUK]

You could use Conditional Formatting, with a formula using MIN function.

Use Menu command, Format/Condtional formatting ( on the whole range of cells ), and select Formula from the left drop down, and type this formula into the entry box :

=A1=MIN($A$1:$A$3)

and press the Format button, and choose Bold Red font. Press OK, OK to finish it off and you're done.

Cheers, Glenn.

 

[bluedragon2]

in the conditional formating, put:

formula =A1=MIN($A$1:$A$3)



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[BlueHorizon]

Hi agian,
Thanks!! A star to both of you!! I knew you'd know -

Best!!

Best,
Blue Horizon

http://www.bluehorizontraining.com

 

[BlueHorizon]

One more question,

Is there an easy way to copy that to a hundred rows? I tried click and drag, copying and creating a macro and nothing works.

Thanks in advance,


Best,
Blue Horizon

http://www.bluehorizontraining.com

 

[macropod]

If you copy the formatting of A1:A3 down for 100 rows with the existing conditional formatting equation, the condition will only trigger whenever a cell on a given row matched the minimum of A1:A3. This is caused by the mix of absolute and relative referencing used. For example, the conditional format formula in:
A1 is =A1=MIN($A$1:$A$3)
A2 is =A2=MIN($A$1:$A$3)
A3 is =A3=MIN($A$1:$A$3)
A4 is =A4=MIN($A$1:$A$3)
A5 is =A5=MIN($A$1:$A$3)
and so on.

So, how do you want to trigger the conditional format? As described above? Or, perhaps whenever the current cell has the minimum:
a) encountered so far, for which you could use - =A1=MIN($A$1:$A1). Note that this will always highlight A1.
b) for rows A1:A100, for which you could use - =A1=MIN($A$1:$A$100). Note that this will only highlight a cell in A1:A3 if it is also the minimum in the range A1:A100.

Cheers

 

[BlueHorizon]

Hi,
I want to trigger the conditional formatting when the lowest value appears in each row. I want to have Excel show me which price is lowest in each row so I quickly can compare vendors for hundreds of parts. Ex:

Part #: A1 A2 A3
2377856 2.3 2.4 2.5
2098756 1.6 1.9 1.3

Because of the mixed references, I realize I can't copy and paste, can't click and drag it down, etc. Tried removing absolute references and that didn't work. I'm puzzled.

So is there a way for me to apply the conditional formatting in each row individually for more than a hundred rows without having to do it to each row separately?

TIA,



Best,
Blue Horizon

http://www.bluehorizontraining.com

 

[GlennUK]

Easy.

Select B2:Y400 ( or whatever range covers your numeric data ) amd use this formula in the conditional formatting:

=B2=MIN($B2:$Y2)

Cheers, Glenn.

 

[BlueHorizon]

That did it, GlennUK! Star for you too!!



Best,
Blue Horizon

http://www.bluehorizontraining.com