Change Excel text color based on data range

Sony / Vgn-cr420e
May 24, 2009 at 08:33:11
Specs: Windows Vista
Hello. I am fairly new to conditional formating in Excel and would appreciate some help with a basic request. I use Excel 2007, and I would like to change the color of my entered text based on a value range.

Here is an example: From cells C9:D16, if the value is > -0.75 and < 0.75, I would like the text in the cell to turn to a specific shade of light green. (Basically, I want it to match the background color of the cell, so that the text appears to be invisible, but the data is still there.) If the value is anywhere outside of these parameters, I would like the text to appear in black so that the user can see the text.

Please forgive any redundancy--I see that this type of question has been answered here before, but although I have tried, I haven't had any luck modifying those answers to fit my issue.

Thank you in advance for your help.

Carrie


See More: Change Excel text color based on data range

Report •


#1
May 24, 2009 at 08:58:17
Select C9:D16

Choose Format...Conditional Formatting...Formula Is...

Enter: =IF(AND(C9>-0.75,C9<0.75),TRUE,FALSE)

Chose Format...Font tab...Color...Choose your text color.

Click OK, OK.

This will CF the entire range.


Report •

#2
May 24, 2009 at 14:15:35
DerbyDad,

Thanks for the quick reply! I must be doing something wrong, though. In Excel 2007, the CF function has its own button on the Home tab. When you click it, it takes you to the drop down menu. The New Rule option takes you to its own submenu, and I can't figure out how to make your rule work within that submenu. Could you provide some additional guidance?

Thanks,

Carrie


Report •

#3
May 24, 2009 at 15:38:05
I believe it's:

Home Tab
Conditional Formatting
New Rule

At the bottom of the top section, select:

Use a formula to determine which cells to format

In the input box

Insert DerbyDad03's formula.

Select the Format button
Select the Fill Tab
Select your pretty color

Click Ok
Click OK

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
May 24, 2009 at 16:35:15
Except that you should probably choose whatever option it is for text color since that is what you are trying to CF.

Report •

#5
May 24, 2009 at 17:13:12
OOPS, Revision:

Select the Format button
Select the Font Tab
Select Color

choose your color.

Click Ok
Click OK

MIKE

http://www.skeptic.com/


Report •

#6
May 24, 2009 at 21:33:50
DerbyDad & Mike,

Thank you both so much! The formulas worked perfectly. Thanks for the assist--I've been working on this issue for days. :-)

Carrie


Report •


Ask Question