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))
Download the completed Excel file here: [ Ссылка ]
Conditional Formatting with Formulas Explained: [ Ссылка ]
View my comprehensive courses: [ Ссылка ]
Connect with me on LinkedIn: [ Ссылка ]
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
