I have a spreadsheet for training dates and need to be able to create
formating on a couple of the columns, the 4th colom (E),contains dates
ddmmyyyy from these dates I need to be able in another column (P) highlight
that the refresher course needs to be done in 3 years time e.i 22/12/2006
refresher course 22/12/2009 can I also put in a generic timescale of 1095
days as this will always be the timescale involved rather than individual
dates as I have thousands of rows, also can I set a condition in another
colum of 1035 days and sent this to an AMBER stage so we know that the course
will need to be re-booked, what formula do I need in each instance ??

Version-Excel 2003
Many Thanks
--
Eva