Gantt Charts

[Rayomand]

I have created a Gantt Chart Template and is working fine. Now, I wish to show the progress (On Time or Delays) in different colors which I am unable to get in conditional formatting.

For example, the planned start day is "1" and end day is "3", while the actual start day is "1" and end day is "5". I wish to show days 1,2,3 in green and days 4 & 5 in red.

Can anyone please help.

Thanx in advance.
Rayo

 

[NARAYANK991]

Hi ,

Please upload your workbook.

Narayan

 

[Rayomand]

Hi Narayan,

Thanks for the reply. PFA the workbook.

Rayo

 

[jayalaxmi]

. Creating a quick project plan / gantt chart using conditional formatting:

Project plans / gantt charts are everyday activity in most of our lives. Creating a simple and snazzy project plan template in excel is not a difficult job, using conditional formatting a bit of formulas you can do it no time.

• First create a table structure like shown above, with columns like Activity, start and end day, day 1, 2,3, etc…
• Now, whenever a day falls between start and end day for a corresponding activity, we need to highlight that row. For that we need to identify whether a day falls between start and end. We can do that with the below formulas,
  =IF(AND(F$8>=$D9, F$8<=$E9),"1","")
  Which means, whenever, the day number represented on the top row is between start and end we will in 1 in the corresponding cell.
• Next, whenever the cell value is 1, we will just fill the cell with a favorite color and change the font to same color, so that we dont see anything but a highlighted cell, better still, whenever you change the start or end dates, the color will change automatically. This will be done by conditional formatting like below:
  
  
• Congratulations, you have mastered the art of creating excel gantt charts now

 

[jayalaxmi]

i hope this can help u Rayomand

 

[NARAYANK991]

Hi ,

I am not sure whether this is what you wanted ; see the file and comment.

Narayan

 

[Pierre]

Hello Rayomand,

My contribution to your problem, hope I understood it correctly.

It may not be the most elegant formula, but it seems to work in all cases. I also added a condition when a task is made earlier than schedule, cell will be in orange

Pierre