Color in an IF statement

[Sharon]

I want to include making text a certain color in my true and false actions of my IF statement. Can I do this? If so, how
=IF(D6>D5,"Overdue","") I want Overdue to be RED.

 

[Frank Kabel]

Hi
not with a formula but have a look at 'Format - Conditional format'.
See
http://www.cpearson.com/excel/cformatting.htm
http://www.contextures.com/xlCondFormat01.html

--
Regards
Frank Kabel
Frankfurt, Germany

I want to include making text a certain color in my true and false

actions of my IF statement. Can I do this? If so, how?

 

[Norman Harker]

Hi Sharon!

Select the cell with your formula:

Format > Conditional Formatting
First drop down - Formula Is:
Second drop down - equal to
Third box - ="Overdue"
Format button
Select format
OK
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH.
See:
http://www.microsoft.com/security/protect/