Trying to create a "Gantt Chart" in Excel

**bradenkeith** · 01-06-2016, 03:20 PM

Ok, so I'm trying to create a tool in Excel that will effectively produce for me a Gantt Chart.

So, on the left side, I have date ranges. 1/27/2016-1/29/2016, 3/8/2016-3/17/2016, etc.

Across the top, I have every date from 1/1/2016-5/1/2016.

What I want to happen (think of this as a grid with an X and Y axis) is that if the date on the top falls within a range on the left, color the corresponding square.

Can't get conditional formatting to work.

Any ideas?

**zbor** · 01-06-2016, 03:34 PM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**ChemistB** · 01-06-2016, 03:54 PM

Here's a gant chart I made for myself. The key dates (start/end) are in columns E and F. I have the colored lines alternating between two colors for greater readability. I also created aa green vertical line that represents Today's date (again to easily see where you are).

Conditional formatting formulas are as follows
=AND(ISNUMBER($E2), $E2<=H$1, $F2>=H$1, MOD(ROW(H2),2)=1) light blue
=AND(ISNUMBER($E2), $E2<=H$1, $F2>=H$1) dark blue but comes after light blue which is checked to stop if true
=H$1=TODAY() green
Is this what you are looking for?