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.
Gantt charts are handy for planning and managing project tasks over time. They give a visual representation of the whole project, displaying progress to date and work to come. In this tutorial you'll learn how to build an Excel Gantt chart 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:
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