Hi

I have made a gant chart in excel, which highlights tasks from a start date to an end date with conditional formatting.

I would now like to make a summarizing line (total), which colors days that are booked by any of the activities.


Gant chart .jpg


Any good advice?

Thanks