Spreadsheet: 539046d1505934603-conditional-formatting-various-rules-in-one-cell-sample
Sheet: Sheet1

 |  | Sample infor - no formulae |  |  |  | 1 | 1 - received | 2a | 2a - Received | Step 2 SLA Met? | 2b. | 2b - received | 3a. | 3b | 3c | 4a | 4a - received | 4b | 5a | 5a - received | 5b | 6a | 6a - received |  | Step 7
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-07-31 00:00:00 |  | 2017-07-05 00:00:00 | Nearly |  | 2017-07-31 00:00:00 | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  |  | 2017-08-25 00:00:00 |  | 2017-08-28 00:00:00 |  |  | 2017-09-15 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-08-22 00:00:00 |  | 2017-09-06 00:00:00 | No |  | Not received | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  |  | 2017-08-25 00:00:00 |  | 2017-08-25 00:00:00 |  |  | 2017-09-16 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-07-11 00:00:00 |  | 2017-07-20 00:00:00 | Yes |  | 2017-07-24 00:00:00 | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  |  | 2017-08-25 00:00:00 |  | 2017-09-01 00:00:00 |  |  | 2017-09-17 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-07-11 00:00:00 |  | 2017-07-21 00:00:00 |  |  | 2017-07-25 00:00:00 | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  |  | 2017-08-25 00:00:00 |  | 2017-09-02 00:00:00 |  |  | 2017-09-18 00:00:00
 |  | sense check with information   Specifically Columns J & K |  |  |  | 2017-06-30 00:00:00 | 2017-07-31 00:00:00 | 2017-07-14 00:00:00 | 2017-07-05 00:00:00 |  | 2017-05-05 00:00:00 | 2017-07-31 00:00:00 | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-06-30 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-08-22 00:00:00 | 2017-07-14 00:00:00 | 2017-09-06 00:00:00 |  | 2017-07-28 00:00:00 | No | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-06-30 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-07-11 00:00:00 | 2017-07-14 00:00:00 | 2017-07-21 00:00:00 |  | 2017-07-28 00:00:00 | 2017-07-24 00:00:00 | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-06-30 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-07-06 00:00:00 | 2017-07-14 00:00:00 | 2017-07-14 00:00:00 |  | 2017-07-28 00:00:00 | 2017-07-14 00:00:00 | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-06-30 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-08-21 00:00:00 | 2017-07-14 00:00:00 | No |  | 2017-07-28 00:00:00 |  | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-06-30 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | No | 2017-07-14 00:00:00 | No |  | 2017-07-28 00:00:00 |  | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-06-30 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-07-12 00:00:00 | 2017-07-14 00:00:00 | 2017-07-31 00:00:00 |  | 2017-05-05 00:00:00 | 2017-08-02 00:00:00 | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-06-30 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-07-20 00:00:00 | 2017-07-14 00:00:00 | 2017-08-02 00:00:00 |  | 2017-05-05 00:00:00 | No | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-06-30 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 |  | 2017-07-14 00:00:00 | No |  | 2017-05-05 00:00:00 |  | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-06-30 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-07-06 00:00:00 | 2017-07-14 00:00:00 | 2017-07-28 00:00:00 |  | 2017-08-22 00:00:00 | 2017-07-28 00:00:00 | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-07-31 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-07-03 00:00:00 | 2017-07-14 00:00:00 | 2017-07-20 00:00:00 |  | 2017-08-22 00:00:00 | 2017-08-04 00:00:00 | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-07-31 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-07-20 00:00:00 | 2017-07-14 00:00:00 | 2017-08-04 00:00:00 |  | 2017-07-28 00:00:00 | No | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-07-31 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-08-04 00:00:00 | 2017-07-14 00:00:00 | 2017-08-14 00:00:00 |  | 2017-07-28 00:00:00 | 2017-08-25 00:00:00 | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-07-31 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-06-21 00:00:00 | 2017-07-14 00:00:00 | 2017-06-21 00:00:00 |  | 2017-07-28 00:00:00 | 2017-06-22 00:00:00 | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-07-31 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-06-07 00:00:00 | 2017-07-14 00:00:00 | No |  | 2017-05-05 00:00:00 |  | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-07-31 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-08-22 00:00:00 | 2017-07-14 00:00:00 |  |  | 2017-05-05 00:00:00 |  | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 | 2017-09-17 00:00:00 | 2017-09-27 00:00:00 |  | 2017-07-31 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-08-22 00:00:00 | 2017-07-14 00:00:00 |  |  | 2017-05-05 00:00:00 |  | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 | 2017-09-17 00:00:00 | 2017-09-27 00:00:00 |  | 2017-07-31 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-08-22 00:00:00 | 2017-07-14 00:00:00 | 2017-09-05 00:00:00 |  | 2017-05-05 00:00:00 | No | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-07-31 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | No | 2017-07-14 00:00:00 | No |  | 2017-05-05 00:00:00 |  | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-07-31 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-06-08 00:00:00 | 2017-07-14 00:00:00 | 2017-07-12 00:00:00 |  | 2017-07-28 00:00:00 | 2017-07-12 00:00:00 | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-07-31 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-06-08 00:00:00 | 2017-07-14 00:00:00 |  |  | 2017-07-28 00:00:00 |  | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 | 2017-08-23 00:00:00 | 2017-09-27 00:00:00 |  | 2017-08-31 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-07-14 00:00:00 | 2017-07-14 00:00:00 |  | 2017-07-28 00:00:00 | 2017-07-17 00:00:00 | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-08-31 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-07-03 00:00:00 | 2017-07-14 00:00:00 | 2017-07-25 00:00:00 |  | 2017-07-28 00:00:00 | 2017-09-12 00:00:00 | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-08-31 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-08-22 00:00:00 | 2017-07-14 00:00:00 | 2017-09-05 00:00:00 |  | 2017-09-14 00:00:00 |  | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-08-31 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-07-21 00:00:00 | 2017-07-14 00:00:00 | 2017-08-03 00:00:00 |  | 2017-09-14 00:00:00 | 2017-08-14 00:00:00 | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-08-31 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | No | 2017-07-14 00:00:00 | No |  | 2017-09-14 00:00:00 |  | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  | 2017-08-25 00:00:00 | 2017-09-01 00:00:00 |  | 2017-09-15 00:00:00 | 2017-09-20 00:00:00 |  | 2017-09-27 00:00:00 |  | 2017-08-31 00:00:00