Excel Help - Color coding based on start date + number of weeks

Hello,   I am working on creating a Ghantt chart on excel using the start date + number of weeks, I want to show this highlighted with a specific color based on the type of project. I have attached...