|Subject:||A better explanation of help required|
|Date:||Sat, 20 May 2006|
I have to assess my team of 70 every six months so if the 1st assessment is
01.01.06 then the next is due on the 01.12.06.
I now how to show the next date due by taking the cell +180 to give me the
next assessment date.
What I want to do is get a reminder 120 days (Coloured Green) from the
original assessment date and then a final reminder at 160 days(Coloured Red )
so I do not miss their assessments
I have tried to use conditional formating but I do not know how to get it to
work as each original assessment dates are different depending when they
joined the team.
How do I get Excel to calculate "X" amount of days forward and change colour
to give me a visual reminder without trawling through the spreadsheet.
Column E Column F
Original Dates Dates in six months time
19 May 2006 15 November 2006
26 August 2005 22 February 2006
27 August 2005 23 February 2006
28 August 2005 24 February 2006
29 August 2005 25 February 2006
30 August 2005 26 February 2006
Any help will be most appreciated