Bob


I have tried this but it does not appear to work

the 2 columns that I need to format are the whole of col L or where the data
will be input L4,this is the completion date and in Columns 04 and P4 i need
to format so I can set a reminder condition at 1035 days(column 0) and also
column P4 the expiry date , I can set this col P to a date of 1095 days but
I'm not to sure of the formula, someting like P$1095 ?? as a cell value - I
am hoping to be able to use the date that the assessments are completed and
then use this then to set warning dates at 1035 days as amber and then the
expiry date as 1095-but I'm unsure where I need to set the conditions in
particular which columns needs what formula or cell value greater or less
than etc ...

Do I need to in each case select the whole column before so it will include
blank cells as well ???

Thanks, much better at Access but struglling with excel at the mo

--
Eva


"Bob Phillips" wrote:

P2: = DATE(YEAR(E2)+3,MONTH(E2),DAY(E2))

Not sure what you are asking for the second part. I get the drift but not
the detail.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Eva" wrote in message
...
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