Formatting smallest number in a range?

P

penglvr

How do I make the smallest number in a specific range show up as red? I need
to automatically be able to see what is the lowest price on a certain item
between three different companies without doing it by hand every time there's
a price change. Any help is appreciated.
 
G

Guest

Hi

You should have a look at Format/Conditional Format. If you numbers are in
column A, select the whole column and use the Formula Is option with this
formula:
=A1=MIN(A:A)

Hope this helps.
Andy.
 
P

penglvr

Yes, it does help - somewhat. What does the first =A1= represent? My numbers
are in rows and don't start at the beginning of a row. For example:
A B C D
3> Flooring $32 $30 $21
I used =B3=MIN(B3:D3) which worked but when I format the next row:
4> Carpet $15 $12 $20
with =B4=MIN(B4:D4) it formats the 2 lowest values.
I thank you for what you have given me so far. I'm very happy that this is
at least possible.
Amy
 
G

Guest

Hi
You've selected the column, so A1 is the active cell (inverse). Your formula
has to refer to that cell. So it compares A1 with the whole of the A column.
When the whole column is done at once, the format automatically increments
itself down the rest of the cells.

Andy.
 
Top