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.