Easy Excel Gantt Charts - Perfect for Project Management

In this video I’m going to show you how easy it is to build Gantt charts in Excel using Conditional Formatting. We’ll also look at how we can highlight tasks that are overdue and the current date.

Note: the formula in column F should be: =IF(ISBLANK(B5),"",WORKDAY.INTL(B5-1,C5,1))

0:00 Excel Gantt Chart uses
0:22 Setting up for Gantt Charts in Excel
0:59 Calculating the Completion Date using WORKDAY.INTL
1:59 Gantt Chart Conditonal Formatting Rules
4:44 Highlight Overdue Tasks
6:19 Highlight the C urrent Date
7:08 Troubleshooting Conditional Formats

[MohammadArifRahim]

I had used this technique before. But yours have lots of layers. Thanks for sharing. Loved it.

[manojjohnaxelsson]

Every time i come back here to look up something, it is obvious to me that you are the AI (maybe even an alien) in the excel world that is currently in a human experience. Thank you Mynda!

[learningwithmaliha]

Truly an amazing method to use Gantt Chart in Excel.

[RandyMcNeil]

Was all set to see the use of dependencies on tasks and the effects of a change or delay of one item and how it affected the rest. But for a standard training representation of how to format using conditional data in a real life gant chart, this was very good

[IvanCortinas_ES]

Good approach to conditional formatting in a Gantt chart. Thank you very much Mynda. The issues of the channel are very practical.

[GingerMan]

Excellent video as always - thanks!

I wish Excel allowed you to create names for conditional formatting rules - it would be so much easier to understand what potentially complex formulae are doing if instead of seeing the formula in the manage rules dialogue, you saw a user defined name that described the result of the formula.

[brianwied]

Great tutorial, this is better than buying MS Project and it integrates better into program management dashboards.

[Chiddu_Chingari]

Hi Mynda, truly amazing!!👌🏻 Thank you so much for this video on Gantt Charts. Really means a lot to me. You're really helping many professionals like me to develop ourselves, gain knowledge & explore more.

Take care & stay blessed.

[SteveOh]

Ooooh - this looks very useful. I use MSP a lot but it's not easy to read if you're not a regular user; these charts are a lot more accessible.

[rigobertogarcia]

Excellent as always, Mynda. Thank you very much for sharing such valuable knowledge that results in a profound improvement of our professional development.

[robertososa]

Amazing as always Mynda! Thanks a lot! 👏👏👏

[c.s.m.k]

Very Cool. Enjoyed this example for project management visualization

[yahyaalsulaiman]

u re awesome and really appreciate that you are sharing such brilliant knowledge... you always make my day

[chrism]

Thanks Mynda! I've used something similar before but I like yours a bit better.

[andriikulishov]

Dear Mynda, it looks absolutely fantastic!
Would use that at work.

[dragonkungfu]

your videos help me a lot thank you very much. I also share your videos to collegues also. You are very talented.

[magsarjavbolor]

Hi Mynda. Thank you for all that you do. It was very helpful!

Could you tell me the way that we can highlight the task in column A? 😬

[colinwheatley]

Great video Mynda, however, is there a week function rather than days? Just so you can compress the Gantt field of view..

[darrylmorgan]

Hi Mynda!Really Great Tutorial, Will Definitely Be Trying This Cool Technique Out...Thank You :)

[diamondsandlipgloss]

this is exactly what i need since i don't have a power project license