Formula for colors
 

Hi,
In my range A8:A20, I have formulas which return Dollars
and cents. All the numbers are displayed in black.

How can I incorporate in my formula (it's just an If
statement), a way to change the color of the lowest number
in the range to Red.

Thankyou.

Formula for colors
 

Select your range A8:A20
click FormatConditional format

In the first box: formula is
in the 2nd box: =A8=SMALL($A$8:$A$20,1)

Click the format click on the Color box and click on re

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Formula for colors
 

Thankyou for your prompt reply.
Works perfectly and I've learned something to boot.
Kind regards

-----Original Message-----

Select your range A8:A20
click FormatConditional format

In the first box: formula is
in the 2nd box: =A8=SMALL($A$8:$A$20,1)

Click the format click on the Color box and click on
red


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

.