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

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.

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


"Bill" wrote in message
...
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.

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

-----Original Message-----
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.
.