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???? |
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???? |
All times are GMT +1. The time now is 08:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com