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
> Does anyone know if it's possible to have a font color operator?
>
[quoted text clipped - 13 lines]
> simserob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36635
> View this thread: http://www.excelforum.com/showthread.php?threadid=573587
simserob - 20 Aug 2006 23:50 GMT