One way (my choice, at the moment):
With your figure 50 and Over OR Less than 50 in Call A1
In B1 enter = If($A$1 = 50, "On Schedule","Behind Schedule")
Also, with B1 active, Got to Foramt Conditional Formatting and
Select FormulaIs, enter =$A$1=50 then Click on the Format button
Select Font Color Green OK, Ok,

Stay in Conditional formatting and click on the Add... button
There again select FormulaIs = $A$1<50 Click on the Format button
Selct Font Color Red, Ok. Ok.

You should be Good to Go !!
HTH
Jim May



"simserob" wrote
in message :

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