Automatic Font Color

G

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top