Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / August 2006

Tip: Looking for answers? Try searching our database.

Font Color Function

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
simserob - 20 Aug 2006 22:32 GMT
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 - 20 Aug 2006 22:53 GMT
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
Thanks a lot ma
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.