Date expiry notification

Hi all.
I have a DB with many columns in one of them dates [The date of registration] (dd.mm.yyyy) are stored, I would like to be notified when 15 (cell green color), then 30 days (cell red color) will pass from that date, and after 45 days the cell will reset (get back to black color), how to get this done ? Any help will be appreciated.

Thank you in advance.

I think you need to have helper columns!

Column date + 15
where you calculate date of registration + 15
The same with 30 and 45

Then you can in the workbook_open create a check

Please Login or Register  to view this content.

Thank you guys for your replies,

Now after your answers my task a little bit changed...

So the cell that has a date in column "L" has to change it's color in red if 60 days passed, but this will only happen if the cell in column "P" is empty, if the cell in column "P" has any date then nothing has to happen. And if the cell in column "L" will get red after 60 days it will automatically "uncolor" itself if someone will insert a date in column "P".

I hope someone will know the answer...thank you in advance.

The task with the cell changing color I solved like this: =AND(TODAY()-L5>60;L5<>"") but what about other tasks ? In order to solve the whole problem. Thank you.

P.S.: I attached the *.xls file so you would get a better understanding.

Solved like this:

Please Login or Register  to view this content.

All the credits go to Serge