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

[Bill]

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


"Bill" <[email protected]> wrote in message
news:[email protected]...
>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.

[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

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