I've been using the IF () program/pragma for conditional statements and it's
been working well for me. Now, I want to use it for a special condition. If,
for example, if a group of cells is, say, under $100.00, I want my targeted
cell to print that summed $100 in red font. This is similar to formatting a
cell to the currency format but the font color automatically changes to red
(when the currency value id under $0.00). Suggestions?

Hi,

Do: FormatConditional Formatting.

Then do:

Cell Value : Is Less Than : 100

Then just pick what formatting you want.

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=548572