You want to use CONDITIONAL FORMATTING. After clicking on the cell you want
to check, open the conditional format window, change CELL VALUE IS to FORMULA
IS in the combo box. The you will have a space to enter the formula. If I
understand what you are trying to do, lets say A1 = 10/30/2007. Want to to
check that date against today's date and flag it if it is more than a year
away. If that is the case, then the formula you need to type in is:

=AND(A1<"", A1TODAY()+365)

Suggestion: If you are using a dark background, ie red, blue, black, etc, I
would change the font to white also.

Les

"heather" wrote:

I need to know how to change the background color of a cell based on data
entered. Such as a date that is more than a year the background of that cell
turn red.