Spreadsheet: 882950d1731426591-help-with-conditional-formatting-worksheet
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | DATE |  |  |  | SEI + CPS + WRAP * <=240 units 2 weeks
 |  |  |  |  |  |  |  |  |  |  |  | 13 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 15 |  | 16 | 8
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 17 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 16 | 8
 |  |  |  |  |  |  |  |  |  |  |  | 19 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 21 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 24 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 26 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
 |  |  |  |  |  |  |  |  |  |  |  | 13 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 15 |  | 16 | 8
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 17 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 16 | 8
 |  |  |  |  |  |  |  |  |  |  |  | 19 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 21 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 24 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 26 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
 |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 15 |  | 16 | 8
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 17 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 16 | 8
 |  |  |  |  |  |  |  |  |  |  |  | 19 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 21 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 24 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 26 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
 |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 21 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 24 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 26 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
 |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 21 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 24 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 26 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
 |  |  |  |  |  |  |  |  |  |  |  | 13 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 15 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  | 21 |  | 16 | 8
 |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 24 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 26 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
 |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
 |  |  |  |  |  |  |  |  |  |  |  | 13 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 15 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 20 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 17 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 19 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 21 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 16 | 8
 |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 20 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 24 |  | 20 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 12 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 26 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
 |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
 |  |  |  |  |  |  |  |  |  |  |  | 13 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 15 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 17 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 19 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 21 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 24 |  | 20 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 26 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
 |  |  |  |  |  |  |  |  |  |  |  | 13 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 15 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 17 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 19 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 21 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 24 |  | 20 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 26 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
 |  |  |  |  |  |  |  |  |  |  |  | 13 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 20 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 15 |  | 16 | 8
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 20 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 17 |  | 20 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 20 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 19 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 21 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 20 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 24 |  | 16 | 8
 |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 20 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 26 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
 |  |  |  |  |  |  |  |  |  |  |  | 13 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 20 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 15 |  | 16 | 8
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 20 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 17 |  | 20 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 20 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 19 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 21 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 20 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 24 |  | 20 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 20 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 26 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
 |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
 |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
 |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
 |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 32
 |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
 |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 15 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 17 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 21 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 24 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  | 26 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
 |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  | 21