Hello, I am using a Gantt chart with conditional formatting that highlights cells with a color when they fall within specific 'start' and 'end' dates. I would like to additional conditional formatting to have the highlighted cells point to a reference cell, and mirror that text within the colored cell. I've attached a file with an example. Thanks in advance for your time and assistance!
Best,
Robert
