Color in an IF statement

Sharon · Apr 28, 2004

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 · Apr 28, 2004

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

Sharon said:
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 · Apr 28, 2004

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
[email protected]

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/