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)
Attached is my sample.
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.
