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:

=AND(task_end>=I$5,task_start<J$5)

 

Attached is my sample.

2 Replies

@SamCS 

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.

@HansVogelaar 

 

You are amazing, thank you!