I have created a gantt chart for a project. My gantt chart extract the dates that given and shows the duration. I used conditional formatting to show the bars in one color. However, my managers wants to assign different colors for each tasks that are owned by the project owners. I am stuck on how to automatically apply the colored bars when we change the names. For example, if the project owner is Stacey, then the bars needs to automatically change it's color to purple.
Solved by M. C. in 24 mins