Afternoon all...

I'm creating a large Project Database for the company I work for. I have had many hurdles during this, and have found answers to most of my questions. However, this one I'm struggling with.

My file has several worksheets for different areas of the company. There is also an "Overview" sheet which brings the main points of the rest of the sheets into one list that shows the projects current status.

The next thing I wish to add, is a formula, and conditional format based on dates and deadlines.

Now, on the overview page, I will have todays date shown in a cell.

On the other sheets, I will have a list of projects and sub-projects, each of which will have a deadline (So far, the deadlines are "Sep 2012" etc instead of an exact date, but I can change that to the first or last date of each month it it means I have to get the formula/format to work).

So, for example, what I'd like is a Cell to shows todays date (1/8/12 [or 8/1/12 to the Americans ]), I know the code is =Today()

Then the projects will have target dates set. What I want to happen is the following:

If todays date is 1 month from the deadline, I want it to highlight Orange
If todays date is 2 months from the deadline, I want it to highlight Yellow
If todays date is 3+ months from the deadline, I want it to highlight Green
If todays date has passed the deadline date, I want it to highlight Red

Any help would be much appreciated.