Alerting for a due date

[GE]

I posted this earlier in the week but unfortunately the fixes proposed did not work.

I have a cell with a due date which i want to alert me by changing colour when the date is reached.
EG. date due is 1/1/03,so i want the cell to turn red on that date. If possible i would also like a pre alert of say 5 days before this time by turning green.

Thanks

 

[Jack in the UK]

Good news well done , any time a pleasure


Jack