| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Font Color Function
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Font Color Function
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Font Color Function
Thanks a lot man -- simserob ------------------------------------------------------------------------ simserob's Profile: http://www.excelforum.com/member.php...o&userid=36635 View this thread: http://www.excelforum.com/showthread...hreadid=573587 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and paste Excel chart in Word -- font compresses | Charts and Charting in Excel | |||
| Font used in Word won't come up in Excel - usg as data base-envel | Excel Discussion (Misc queries) | |||
| Default font for Comments | Excel Worksheet Functions | |||
| Why is first font action v-e-r-y slow? | Excel Discussion (Misc queries) | |||
| How to change the default font and size of "comments"? | Excel Discussion (Misc queries) | |||
Hybrid Mode
