Formatting smallest number in a range?
 

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.

Formatting smallest number in a range?
 

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.

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

Formatting smallest number in a range?
 

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

"Andy" wrote:

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.

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

Formatting smallest number in a range?
 

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.

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

"Andy" wrote:

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.

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