Conditional Formatting Formula for Gantt Chart Template

%3CLINGO-SUB%20id%3D%22lingo-sub-2607919%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20Formula%20for%20Gantt%20Chart%20Template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2607919%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20using%20a%20Gantt%20chart%20with%20conditional%20formatting%20that%20highlights%20cells%20with%20a%20color%20when%20they%20fall%20within%20specific%20'start'%20and%20'end'%20dates.%26nbsp%3B%20I%20would%20like%20to%20additional%20conditional%20formatting%20to%20have%20the%20highlighted%20cells%20point%20to%20a%20reference%20cell%2C%20and%20mirror%20that%20text%20within%20the%20colored%20cell.%26nbsp%3B%20I've%20attached%20a%20file%20with%20an%20example.%26nbsp%3B%20Thanks%20in%20advance%20for%20your%20time%20and%20assistance!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERobert%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2607919%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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 

0 Replies