Conditional Formatting w/ Gantt Chart

Hi,

I'm using Excel 2003, and I'm struggling to create a Gantt Chart with conditional formatting using months as the scale.

I recently saw the post:

http://www.excelforum.com/excel-prog...-in-cells.html

This gives nearly what I need, but it doesn't seem to work if a mid-month date is give. For example:

A1 B1 C1 D1 E1 F1
Project # Start Date End Date 10/1/2009 11/1/2009 12/1/2009
1 10/15/2009 12/15/2009 *******
2 10/01/2009 12/01/2009 *************************

The conditional formula used in the above example/post is:
=AND(D$1<=$B2,D$1>=$C2).

However, as you can see the way this formula works is that it results in cutting off the mid-month. I'd like to have it where Project 1 starting on Oct 15, it would include October as part of the project timeline.

Please Help as this has been very frustrating to try and figure this out. Any thoughts/suggestions would be greatly appreciated!!

ormont02

Replace the current CF formula with this:

=and(month(E$1)>=month($B2),year(E$1)>=year($B2),month(E$1)<=month($C2),year(E$1)<=year($C2))

Excellent thanks for that formula, used it to create this to complete this configurable 36 month Gantt timeline
Start year, and the timeline color is configurable based on the status code for which the condition was added to your AND formula.

Where =AND((G$3>=$C4-(DAY($C4)-1)),G$3<=$D4,$F4="Late") would be assigned a red interior format.

Example attached

Terry Magdy
Project Manager, Supplier Development
Pratt & Whitney Canada

RShoener, welcome to the forum

Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

I had no problem downloading the file from post #7, and, despite only having 1 post, I dont see why you would have an issue either - at least from the forum's side. Perhaps the server or anti-virus on your side is stopping you?