SOLVED

Need Help with Formula complex

%3CLINGO-SUB%20id%3D%22lingo-sub-3044053%22%20slang%3D%22en-US%22%3ENeed%20Help%20with%20Formula%20complex%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3044053%22%20slang%3D%22en-US%22%3E%3CP%3ESee%20attached%20picture.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20column%20G%20'Referral%20Date'%20text%20to%20turn%20Bold%20when%20column%20E%20does%20not%20have%20a%20'Yes'%20documented%20in%203%20days%20and%20red%20after%205%20days.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20also%20need...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20background%20of%20cell%20in%20column%20G%20'referral%20date'%20to%20turn%20color%20A%20if%20column%20J%20is%20empty%20after%203%20and%20color%20B%20if%20blank%20after%205%20days.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHuge%20help.%20I%20hardly%20knew%20where%20to%20start%20here.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3044053%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

See attached picture.  

 

I need column G 'Referral Date' text to turn Bold when column E does not have a 'Yes' documented in 3 days and red after 5 days. 

 

But also need...

 

the background of cell in column G 'referral date' to turn color A if column J is empty after 3 and color B if blank after 5 days. 

 

Huge help. I hardly knew where to start here.  

 

 

 

2 Replies
best response confirmed by andermanrn (Occasional Contributor)
Solution

Hi @andermanrn 

 

you need to setup a set of rules for conditional formatting:

DTE_0-1640159277586.png

DTE_1-1640159295511.png

In the attached Excel file you will find my example. I'm not sure if it meets all requirments but it should give you at least a good start.

 

 

 

Worked perfectly. Thank you!