A better explanation of help required

Giganews Newsgroups
Subject: A better explanation of help required
Posted by:  Elvey
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

Elvey

Replies