Spreadsheet: 690431d1597094306-conditional-formatting-formula-for-multiple-conditions-matching-testconditional-format-3_revb
Sheet: Follow-Up Monitoring

Employee Monitoring for COVID 19 |  |  |  |  | Work Locations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee  Information |  |  |  |  | Household Information |  |  |  |  | Screen for Return to Work
Employee Last Name | Employee First Name | Employee DOB | Employee Supervisor | OLD work locations (do not use) | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | Known Work Exposure | Date of Onset of Symptoms | Employee Test Date | Employee Result | Monitoring Type (Active/ Passive) | Employee Counseling Date | Monitoring Start Date | [NAME] | Test Date | Result |  |  | Date Screened | Result | Date Screened | Result
Test Person | 1 |  |  | g |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | No |  | 2020-06-26 00:00:00 | positive | passive | 2020-06-26 00:00:00
Test Person | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | No | 2020-07-01 00:00:00 | 2020-07-02 00:00:00 | negative | passive | 2020-07-02 00:00:00 | 2020-07-01 00:00:00
Test Person | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | No | 2020-07-01 00:00:00 | 2020-07-02 00:00:00 | negative | passive | 2020-07-02 00:00:00 | 2020-07-01 00:00:00
Test Person | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | No | 2020-07-01 00:00:00 | 2020-07-02 00:00:00 | negative | passive | 2020-07-02 00:00:00 | 2020-07-01 00:00:00
Test Person | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | No | 2020-07-01 00:00:00 | 2020-07-02 00:00:00 | negative | passive | 2020-07-02 00:00:00 | 2020-07-01 00:00:00
Test Person | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | No | 2020-06-29 00:00:00 | 2020-07-02 00:00:00 | negative | passive | 2020-07-02 00:00:00 | 2020-06-29 00:00:00
Test Person | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | no | 2020-07-04 00:00:00 | 2020-07-06 00:00:00 | negative | passive | 2020-07-06 00:00:00 | 2020-07-04 00:00:00
Test Person | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | Unknown | 2020-07-01 00:00:00 | 2020-07-06 00:00:00 | negative | passive | 2020-07-06 00:00:00 | 2020-07-01 00:00:00
Test Person | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  | no | 2020-07-07 00:00:00 | 2020-07-08 00:00:00 | positive | passive | 2020-07-08 00:00:00 | 2020-07-07 00:00:00
Test Person | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Yes | N/A | 2020-07-15 00:00:00 | negative | passive | 2020-07-15 00:00:00 | 2020-07-13 00:00:00
Test Person | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Yes | N/A | 2020-07-15 00:00:00 | positive | passive | 2020-07-15 00:00:00 | 2020-07-13 00:00:00
Test Person | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | yes | N/A | 2020-07-15 00:00:00 | negative | passive | 2020-07-15 00:00:00 | 2020-07-13 00:00:00
Test Person | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | no | 2020-07-17 00:00:00 | 2020-07-20 00:00:00 | positive | passive | 2020-07-20 00:00:00 | 2020-07-17 00:00:00
Test Person | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | no | 2020-07-16 00:00:00 | 2020-07-17 00:00:00 | positive | passive | 2020-07-20 00:00:00 | 2020-07-16 00:00:00
Test Person | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | no | 2020-07-11 00:00:00 | 2020-07-20 00:00:00 | positive | passive | 2020-07-20 00:00:00 | 2020-07-11 00:00:00
Test Person | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | yes | N/A |  | not tested | passive | 2020-07-20 00:00:00 | 2020-07-16 00:00:00 |  | If you leave the date blank, then it keeps the location highlighted.
Test Person | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | no | 2020-07-17 00:00:00 | 2020-07-17 00:00:00 | negative | passive | 2020-07-17 00:00:00 | 2020-07-17 00:00:00
Test Person | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | yes | N/A |  | not tested | passive | 2020-07-20 00:00:00 | 2020-07-16 00:00:00 |  | Same as above.  Not necessarily a problem, if we remember to enter the date in W.
Test Person | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | yes | 2020-07-17 00:00:00 | 2020-07-20 00:00:00 | negative | passive | 2020-07-20 00:00:00 | 2020-07-17 00:00:00
Test Person | 20 |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  | no | 2020-07-14 00:00:00 | 2020-07-21 00:00:00 | negative | passive | 2020-07-21 00:00:00 | 2020-07-14 00:00:00 |  | In theory, the location on this line *SHOULD* be highlighted, based on what I entered in Row 31.
Test Person | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | yes | 2020-07-21 00:00:00 | 2020-07-27 00:00:00 | negative | passive | 2020-07-27 00:00:00 | 2020-07-21 00:00:00
Test Person | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | yes | 2020-07-25 00:00:00 | 2020-07-27 00:00:00 | negative | passive | 2020-07-27 00:00:00 | 2020-07-25 00:00:00
Test Person | 23 |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | no | 2020-07-20 00:00:00 | 2020-07-25 00:00:00 | positive | passive | 2020-07-29 00:00:00 | 2020-07-20 00:00:00
Test Person | 24 |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no | 2020-07-22 00:00:00 | 2020-07-28 00:00:00 | negative | passive | 2020-07-29 00:00:00 | 2020-07-22 00:00:00
Test Person | 25 |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | no | 2020-07-27 00:00:00 | 2020-07-27 00:00:00 | negative | passive | 2020-07-27 00:00:00 | 2020-07-27 00:00:00
Test Person | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | no | 2020-07-30 00:00:00 | 2020-08-03 00:00:00 | positive | passive | 2020-08-03 00:00:00 | 2020-07-30 00:00:00
Test Person | 27 |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  | no | 2020-08-01 00:00:00 | 2020-08-01 00:00:00 | negative | passive | 2020-08-01 00:00:00 | 2020-08-01 00:00:00
Test Person | 28 |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  | 2020-08-03 00:00:00 | 2020-08-03 00:00:00 | negative | passive | 2020-08-05 00:00:00 | 2020-08-03 00:00:00
New Test | A |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  | 2020-07-13 00:00:00 |  |  |  |  |  | This location should not be highlighted, but because the date is before the previous row, it is staying highlighted.
New Test | B |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00
New Test | C |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-06-25 00:00:00