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

B

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

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
 
Top