Feb 12 2018
02:13 AM
- last edited on
Jul 25 2018
11:01 AM
by
TechCommunityAP
Feb 12 2018
02:13 AM
- last edited on
Jul 25 2018
11:01 AM
by
TechCommunityAP
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
Feb 12 2018 08:04 AM - edited Feb 12 2018 08:22 AM
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