Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,805
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Checkbox to change background color, font color and remove/ add bo Sara Excel Discussion (Misc queries) 2 May 1st 23 11:43 AM
Changing Font color based on font type or size John Excel Discussion (Misc queries) 2 February 7th 08 12:50 AM
How do I change the AUTOMATIC color in Excel for the font? Valerie Excel Discussion (Misc queries) 1 September 19th 06 07:18 PM
Default Border, Font Color, and Cell Background Color Elijah Excel Discussion (Misc queries) 1 October 28th 05 04:10 PM
My fill color and font color do not work in Excel Std Edition 2003 chapstick Excel Discussion (Misc queries) 1 September 11th 05 08:48 PM


All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"