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: https://bit.ly/3xKbYYF
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 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