Oct 29 2021 10:43 AM
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.
Oct 29 2021 12:37 PM
@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.
Oct 29 2021 01:14 PM
@Hans Vogelaar
You are amazing, thank you!
