Forumla/Formatting Cells Based on Date/Deadline Approaching

[-Mat-]

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.

[DBY]

Hello
Take a look at the attached file. It might give you an idea on how to apply some conditional formatting to your project with the conditions you describe.

Hope this helps.
DBY

[-Mat-]

Thanks....

Managed to figure out the answer about an hour after this post lol

Much appreciated for taking time to give an answer

[Extremebeing]

DBY,

I looked at your attachment and I could see the cell colour changes in sync with the date changes but I couldnt view the formatting for the colour change. Can you tell me where I should look for that please?

Thanks

[DBY]

Extremebeing

Technically you should start a new thread and provide a link to this thread as a reference, as putting questions into another member's thread breaks rule # 2 of the Forum. But to answer your question:

Select cells B5:B14 and go to Conditional Formatting on the Home Ribbon. Select Manage Rules. There you can see the Conditional formatting rules. Click Edit to see each formula.

If you need to know more, create a new thread and all forum members will be able to help you.

Regards
DBY

[Cutter]

@ -Mat-

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.