Use conditional formatting to fill x amount of cells before a date in a “gantt”
I have created a gantt chart in excel. Lefthand section for project details and righthande section for timeline as per the screenshot -> (https://i.sstatic.net/fqtyrp6t.jpg).