Forum Discussion
None None
Feb 12, 2018Copper Contributor
Conditional Formatting Gantt Chart
Hi,
I try to create an Auto weekly Gantt Chart for my project use. But I am stuck with the formula to change the cell color.
Pls refer to attach.
Thank you
- Willy LauSteel Contributor
I have attached a modified file. I changed the worksheet name as "Example". I also listed the steps in the worksheet.
Basically, I guess you want to show the dominating phase in the week by its colour. Hence, I created a numbers of formula to find out which phase has the most number of days in the week.
The formula to calculate the overlap days between 2 date ranges is from the following website:
https://exceljet.net/formula/calculate-date-overlap-in-days