MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to indicate a cell with the lowest number in a range?


Posted by Dennis on August 03, 2001 7:39 AM

Does anyone know how to indicate which cell in a range has the lowest value.

For example, I have a range of values:
$200 $100 $300

I would like to format the cell containing the lowest value ($100) in yellow.

Any help would be greatly appreciate. Thank you.


Posted by Cory on August 03, 2001 8:12 AM

Try this: If your range is in col A (A1,2,&3), in Cell B1 type "=Min(" and highlight the range you want to find the lowest number in then press enter. Now go to Format --> Conditional Formatting, change the "Between" to "equal to", then pu "=B1" in the next box. Once you've done that, click Format (on the conditional formatting dialog box) and choose the font color and style you want (yellow). Click OK then OK again and you should be there!

Cory

Posted by Aladin Akyurek on August 03, 2001 8:34 AM

1) Select the range of the values.
2) Activate the option Format|Conditional Formatting.
3) Select Cell Value Is then Equal To, and enter: =MIN($A$1:$A:$3)
4) Activate Format, select a color via Color on the Fonts tab.
5) Click OK.

Assumed your dollar values to be in A1:A3.

Aladin

Posted by Dennis on August 06, 2001 10:34 AM

Thank you!

Thank you everyone. It works great!