Automatic Font Color

[goingcrazy]

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

 

[Sheeloo]

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.