Gantt Chart Help with Conditional Formatting

Copper Contributor

I am using a Gantt Chart template.  I want to change the color on the calendar cells based on who the task is assigned to. Here is the current formula:



Attached is my sample.

2 Replies


See the attached version.

You had lots of duplicate rules; I reduced them to 3 for the Gantt chart area, then added rules for the names.



You are amazing, thank you!