Does anyone know if it's possible to have a font color operator?

What I'm trying to do is have it so if another cell is displaying a
number above, let's just say 50 for example, it will say in green font
"On Schedule" or if it's lower than 50 it will say in red font "Behind
Schedule".

I understand now how to get it to say the text but I'd just like to
know if you can get the font color to change.

Thanks


--
simserob
------------------------------------------------------------------------
simserob's Profile: http://www.excelforum.com/member.php...o&userid=36635
View this thread: http://www.excelforum.com/showthread...hreadid=573587