Gantt Chart

[corriann1982]

I need help with a Gantt Chart. Basically I am setting up a task management sheet. I want to be able to say: Task #1 starts June 1 and runs for three months and so on and so forth. I've got that part down. What I'm having problems with is that to the right of that, I want to auto-fill color in cells for those corresponding months. So, my cells to the right of the columns "Task Name", "Start Date" and "End Date" are going to be "June 2012", "July 2012", "August 2012", etc. and those need to be able to auto fill color based on when the task starts and ends.

Can someone help me with this?

I guess I should say that the Task Column is A, Start Date is C, End Date is D. The months/years start at E and follow.

 

[RonB1111]

1. Make sure your dates in E1 and across are in date format using the 1st of the month. (ie: "June 2012" is entered as 6/1/12 -- you can still have it display as June 2012 by right-clicking, format cells, custom, then entering this in the Type box: mmmm yyyy

2. Select E2 down and across to the end of your data

3. Select Conditional Formatting, Formula Based and enter this formula:

=AND(DATE(YEAR(E$1),MONTH(E$1)+1,0)>=$C2,E$1<=$D2)

4. Click Format - Pattern and select the color you'd like, OK, OK

 

[corriann1982]

@RonB1111-My faith in humanity has been restored. Thank you for your genius!

 

[RonB1111]

You're welcome. Thank you for providing feedback.