Hello
I am trying to set up conditional formatting rules for the following scenario:
I have 3 date-formatted columns: Date A, Date B and Submission Date in columns A,B and C.
I want to format cells in column C according to the following rules:
- Date B is less than 8 days AFTER Submission date - FILL RED
- Date B is between 8 and 14 days AFTER Submission date - FILL AMBER
- Date B is more than 14 days after Submission date - FILL GREEN
- If Date B is blank apply the above rules to Date A
I have been able to come up with rules that work for the first three steps but have got stuck with applying to Date A if Date B is blank. Any help wpuld be greatly appreciated.
Simon