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 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

[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" <[email protected]> wrote
in message news:[email protected]:

> 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

[simserob]

Thanks a lot man