Change Text Color With Formula

**natepen** · 01-19-2007, 02:01 PM

Hello,
I currently have a percent formula that will give me a positive or a negative percent but I was curious if it's possible to create a formula that will change the text green if its positive and red if it's negative. The formula that I currently am using for this cell is:
=IF(AM20=0,"",CJ20/AM20)

Thanks
Nate

**VBA Noob** · 01-19-2007, 02:04 PM

Hi,

Try conditional formatting and setting up two conditions

Condition 1 for <
Condition 2 for >

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

VBA Noob