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