Font Color Function

[simserob]

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
number above, let's just say 50 for example, it will say in green fon
"On Schedule" or if it's lower than 50 it will say in red font "Behin
Schedule".

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

Thank

 

[Jim May]

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

 

[Jim May]

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]

Thanks a lot ma

 

[simserob]

Thanks a lot ma