Conditional Formatting Gantt Chart

[None None]

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

[#2]

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