Is there a way to change text color using the Logical IF statemen.

[Guest]

I am using "nested" IF statements and would like to assign color to the text.
I have yet to figure out how to do it if it can be done. Any help would be
greatly appreciated.

 

[Chip Pearson]

You cannot change the color (or any other formatting) of the
result of a formula. You might find the Conditional Formatting
tool useful, found on the Format menu.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Jason Morin]

You can do this through Conditional Formatting:

http://www.contextures.com/xlCondFormat01.html

and in some cases, through custom formatting:

http://www.mcgimpsey.com/excel/conditional6.html

HTH
Jason
Atlanta, GA