Spreadsheet: 856705d1705921292-conditional-formatting-not-applying-to-cells-with-formula-receipted_for_forum-ali_cf_formulas
Sheet: RAW DATA

DAY | DATE | RETURNS SINGLE | RETURNS TRAY SET | RETURNS TOTAL | RETURNS SINGLE INSTRUMENTS | RETURNS TRAY SET INSTRUMENTS | RETURNS INSTRUMENTS TOTAL | DESPATCH SINGLE | DESPATCH TRAY SET | DESPATCH TOTAL | DESPATCH SINGLE INSTRUMENTS | DESPATCH TRAY SET INSTRUMENTS | DESPATCH TRAY SET TOTAL | N/C DIRTY | N/C BYPASSED | N/C RUSTY | N/C TOTAL | ALL PRIORITY (Mon - Sun) |  | PRIORITIES <24HRS | % PRIORITIES RETURNED <24HRS | % PRIORITIES <24HRS | [NAME] | [NAME] | Items in [NAME] | Expected Items | Clean Tech | Clean Man Hours | [NAME] | Expected Items
 | 2023-12-23 00:00:00 | 61 | 204 |  | 71 | 5732 |  | 160 | 340 |  | 166 | 11138 |  | 7 | 1 | 6 |  |  |  |  |  |  | 9 |  | 12761 |  | 12.69
 | 2023-12-24 00:00:00 | 17 | 93 |  | 17 | 4900 |  | 126 | 270 |  | 134 | 9094 |  | 9 | 7 | 0 |  | 219 |  | 108 |  |  | 3 |  | 3184 |  | 16.63
 | 2023-12-25 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 |  | 0 |  | 0
 | 2023-12-26 00:00:00 | 1 | 21 |  | 32 | 3078 |  | 18 | 127 |  | 32 | 3513 |  | 4 | 0 | 1 |  |  |  |  |  |  | 0.5 |  | 3904 |  | 1.5
 | 2023-12-27 00:00:00 | 74 | 338 |  | 106 | 13478 |  | 81 | 380 |  | 96 | 15091 |  | 9 | 5 | 1 |  |  |  |  |  |  | 24 |  | 18728 |  | 40
 | 2023-12-28 00:00:00 | 101 | 470 |  | 111 | 17810 |  | 92 | 315 |  | 92 | 13364 |  | 11 | 8 | 5 |  |  |  |  |  |  | 16 |  | 17983 |  | 43
 | 2023-12-29 00:00:00 | 141 | 363 |  | 148 | 13874 |  | 188 | 469 |  | 218 | 17784 |  | 20 | 1 | 3 |  |  |  |  |  |  | 16 |  | 15482 |  | 38
 | 2023-12-30 00:00:00 | 56 | 88 |  | 56 | 3046 |  | 106 | 328 |  | 133 | 13802 |  | 15 | 6 | 1 |  |  |  |  |  |  | 3 |  | 13630 |  | 35
 | 2023-12-31 00:00:00 | 9 | 62 |  | 11 | 3297 |  | 91 | 310 |  | 103 | 7849 |  | 7 | 5 | 3 |  | 115 |  | 65 |  |  | 0 |  | 1566 |  | 10
 | 2024-01-01 00:00:00 | 9 | 42 |  | 9 | 2781 |  | 70 | 103 |  | 70 | 4100 |  | 0 | 3 | 0 |  |  |  |  |  |  | 0 |  | 2345 |  | 4
 | 2024-01-02 00:00:00 | 154 | 376 |  | 160 | 13699 |  | 106 | 199 |  | 108 | 10040 |  | 4 | 1 | 1 |  |  |  |  |  |  | 15 |  | 11687 |  | 24
 | 2024-01-03 00:00:00 | 169 | 579 |  | 178 | 19059 |  | 164 | 373 |  | 170 | 11787 |  | 4 | 2 | 0 |  |  |  |  |  |  | 15 |  | 16656 |  | 39
 | 2024-01-04 00:00:00 | 175 | 461 |  | 181 | 14520 |  | 81 | 430 |  | 92 | 14607 |  | 11 | 2 | 3 |  |  |  |  |  |  | 19 |  | 17429 |  | 43
 | 2024-01-05 00:00:00 | 144 | 407 |  | 160 | 12225 |  | 136 | 390 |  | 142 | 13904 |  | 14 | 5 | 8 |  |  |  |  |  |  | 19 |  | 19006 |  | 45
 | 2024-01-06 00:00:00 | 42 | 133 |  | 50 | 5634 |  | 31 | 359 |  | 31 | 13270 |  | 13 | 0 | 1 |  |  |  |  |  |  | 16 |  | 13040 |  | 22
 | 2024-01-07 00:00:00 | 25 | 86 |  | 25 | 3908 |  | 132 | 262 |  | 135 | 7592 |  | 4 | 1 | 2 |  | 96 |  | 63 |  |  | 4 |  | 950 |  | 8
 | 2024-01-08 00:00:00 | 171 | 484 |  | 194 | 18547 |  | 131 | 245 |  | 145 | 8259 |  | 11 | 0 | 1 |  |  |  |  |  |  | 13 |  | 11845 |  | 23
 | 2024-01-09 00:00:00 | 236 | 477 |  | 258 | 14000 |  | 97 | 264 |  | 109 | 8830 |  | 6 | 1 | 3 |  |  |  |  |  |  | 13 |  | 17749 |  | 33
 | 2024-01-10 00:00:00 | 144 | 459 |  | 166 | 18158 |  | 181 | 347 |  | 203 | 16222 |  | 10 | 9 | 1 |  |  |  |  |  |  | 16 |  | 11617 |  | 34
 | 2024-01-11 00:00:00 | 109 | 403 |  | 153 | 15190 |  | 225 | 383 |  | 225 | 13529 |  | 17 | 4 | 2 |  |  |  |  |  |  | 12 |  | 14504 |  | 36
 | 2024-01-12 00:00:00 | 195 | 477 |  | 211 | 1773 |  | 91 | 415 |  | 115 | 15138 |  | 11 | 0 | 3 |  |  |  |  |  |  | 17 |  | 0 |  | 39
 | 2024-01-13 00:00:00 | 162 | 312 |  | 169 | 9585 |  | 32 | 364 |  | 32 | 12944 |  | 5 | 3 | 0 |  |  |  |  |  |  | 10 |  | 0 |  | 14
 | 2024-01-14 00:00:00 | 49 | 293 |  | 58 | 8786 |  | 58 | 223 |  | 61 | 8250 |  | 3 | 1 | 0 |  | 451 |  | 224 |  |  | 6 |  | 0 |  | 20.31
 | 2024-01-15 00:00:00 | 86 | 309 |  | 85 | 12639 |  | 156 | 288 |  | 172 | 10314 |  | 10 | 0 | 2 |  |  |  |  |  |  | 12 |  | 0 |  | 32 |  |  |  |  |  |  |  |  |  |  | Wash OT Hours |  |  | Clean OT Hours
 | 2024-01-16 00:00:00 | 110 | 387 |  | 132 | 11799 |  | 260 | 460 |  | 292 | 12638 |  | 6 | 0 | 2 |  |  |  |  |  |  | 18 |  | 13770 |  | 36.63 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 | 2024-01-17 00:00:00 | 146 | 372 |  | 156 | 10843 |  | 283 | 512 |  | 291 | 13006 |  | 16 | 5 | 6 |  |  |  |  |  |  | 17 |  | 0 |  | 43.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 | 2024-01-18 00:00:00 | 122 | 445 |  | 153 | 15455 |  | 109 | 424 |  | 117 | 15835 |  | 13 | 1 | 5 |  |  |  |  |  |  | 18 |  | 15688 |  | 41.25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | 2024-01-19 00:00:00 | 307 | 502 |  | 0 | 16773 |  | 122 | 462 |  | 129 | 15392 |  | 7 | 1 | 4 |  |  |  |  |  |  | 20 |  | 0 |  | 35.75 |  |  |  |  | Technicians |  |  | Wash | Clean |  |  |  |  | 8
 | 2024-01-20 00:00:00 | 119 | 256 |  | 133 | 7884 |  | 108 | 346 |  | 117 | 11885 |  | 8 | 5 | 1 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | AM | 13 |  | 6 |  |  |  |  |  | 1.75
 | 2024-01-21 00:00:00 | 98 | 321 |  | 106 | 9953 |  | 18 | 238 |  | 18 | 7789 |  | 0 | 7 | 6 |  | 628 |  | 305 |  |  | 7 |  | 0 |  | 6.63 |  |  |  |  | PM | 16 |  | 8 |  |  |  |  |  | 4
 | 2024-01-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | N | 9 |  | 6 |  |  |  |  |  | 1
 | 2024-01-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | O/T
 | 2024-01-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-01-25 00:00:00 |  |  | [NAME] | AND(C2<>"",C2=MIN(dnrCol),ROW(C2)>=COUNT(C:C)-28) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-01-26 00:00:00 |  |  | Me | AND(C2<>"",C2=MIN(dnrCol),ROW(C2)>=COUNT(C:C)-28) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | Technicians ([NAME]) |  |  | Wash | Clean |  | Wash OT Hours |  |  | Clean OT Hours
 | 2024-01-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | AM | 3 |  | 2 |  |  |  |  |  | 4
 | 2024-01-28 00:00:00 |  |  | [NAME] | AND(C2<>"",C2=MAX(dnrCol),ROW(C2)>COUNT(C:C)-28) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | PM | 5 |  | 2 |  |  |  |  |  | 12
 | 2024-01-29 00:00:00 |  |  |  | AND(C2<>"",C2=MAX(dnrCol),ROW(C2)>COUNT(C:C)-28) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | N | 4 |  | 3 |  |  |  |  |  | 10.5
 | 2024-01-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | O/T |  |  |  |  |  |  |  |  | 3
 | 2024-01-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | 2024-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-02-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2024-03-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0