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.

Download the completed Excel file here: https://www.myonlinetraininghub.com/excel-conditional-formatting-gantt-chart

Conditional Formatting with Formulas Explained: https://www.youtube.com/watch?v=Rzz9PyfwiVQ

View my comprehensive courses: https://www.myonlinetraininghub.com/

Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/

0:00 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