Hi!

Assume the date is entered in cell A1

Conditional Formatting
Formula is: =AND(ISNUMBER(A1),TODAY()=A1+22)
Click the Format button and select the style(s) desired
OK out

Biff

"Nospam" wrote in message
...
Please can anyone offer help on how to conditionally format a column of
cells, so that if a date is placed in a cell, ( when I made the visit) the
cell will change colour after , say, 22 days from the date entered.( when
I need to go again )

I visit students and need to keep regular visits on roughly a 3 week
interval and need reminders !!

Does this make sense ?

Bob