Try Conditional Formatting (CD)
For example:
Suppose you want the cell's background color
to change to light green if the value entered is > 10
Click on A1
Click Format > Conditional Formatting
Set under Condition 1:
Cell Value Is | greater than | 10
Click Format button > Patterns tab > Select: light green > OK
Click OK
Now test it out by entering various values into A1
some < 10, some > 10.
The cell color will change to light green with values > 10
For more info, try MVP Debra D's page on CD at:
http://www.contextures.com/xlCondFormat01.html
