Forum Discussion
Gantt Chart Help with Conditional Formatting
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: =AND(task_end>=I$5,task_start<J$5) Attache...
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.
