Gantt Chart

corriann1982

New Member
Joined
Jun 1, 2012
Messages
2
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.
 
Last edited:

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
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:
Code:
=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
 
Upvote 0

Forum statistics

Threads
1,212,144
Messages
6,106,218
Members
448,006
Latest member
oreo2996

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top