High,

Try Conditional formatting (format - Conditional Formatting)

ChooseFormula is and in the box type

=TODAY() - A1 (the cell reference) = 10

Then click on format and choose your colour.

Finally use Format paimter to apply it to all the dates involved.

Hope this helps

Cheers


"Treza Blu" wrote in message
...
I have a spreadsheet where we input a date when we had first communication
with a potential parent/student. I want the cell to change colors when 10
days have past with no contact. In other words I want to be "alerted"
when
we did not follow up with a potential client. Please explain like you are
talking to a second grader because I am a novice user, but I can get it
done
if given good directions.

Many thanks!
T