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

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.

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

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/

Except that you should probably choose whatever option it is for text color since that is what you are trying to CF.

OOPS, Revision: Select the Format button Select the Font Tab Select Color choose your color. Click Ok Click OK MIKE http://www.skeptic.com/

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