Conditional Formatting Formula for Gantt Chart Template

Occasional Visitor

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 

1 Reply
Having the exact same problem. Did you ever figure it out?