Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Font Color
I have an excel document which is comparing the 2008 percentage with the 2009
percentage and depending on if the value is higher or lower than last year, the font color is red or green (red is lower, green is higher). I did not set up the document and I'm not sure how this works... but now the colors are off and it won't let me manually select the font color. Help???? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Font Color
1. Check out the cell format - if you see RED and BLUE in the format then change it to a format you like. 2. Check Conditional Formatting... you should see two conditons - one for Red and one for Blue. Delete them or change the formats as you want. 3. Send the file to me. "goingcrazy" wrote: I have an excel document which is comparing the 2008 percentage with the 2009 percentage and depending on if the value is higher or lower than last year, the font color is red or green (red is lower, green is higher). I did not set up the document and I'm not sure how this works... but now the colors are off and it won't let me manually select the font color. Help???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
How do I change the AUTOMATIC color in Excel for the font? | Excel Discussion (Misc queries) | |||
Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) | |||
My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) |