Spreadsheet: 690756d1597267825-conditional-formatting-formula-for-multiple-conditions-matching-testconditional-format-4
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 | A |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-06-25 00:00:00 | negative
Test | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | No |  | 2020-06-26 00:00:00 | positive | passive | 2020-06-26 00:00:00
Test | C |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  | x |  |  |  |  | 2020-07-01 00:00:00 | positive
Test | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  | highlighted because of Test Employee C (row 5)
Test | E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  | highlighted because of Test Employee C (row 5)
Test | F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 | G |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  | highlighted because of Test Employee B
Test | H |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  | highlighted because of Test Employee B
Test | I |  |  |  | x |  |  |  |  |  |  |  |  |  |  | x |  |  | 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 | K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Yes | N/A | 2020-07-15 00:00:00 | negative | passive | 2020-07-15 00:00:00 | 2020-07-13 00:00:00 |  | highlighted because of Test Employee C
Test | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Yes | N/A | 2020-07-15 00:00:00 | positive | passive | 2020-07-15 00:00:00 | 2020-07-13 00:00:00 |  | highlighted because of Test Employee C
Test | M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | yes | N/A | 2020-07-15 00:00:00 | negative | passive | 2020-07-15 00:00:00 | 2020-07-13 00:00:00 |  | highlighted because of Test Employee C
Test | N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  | highlighted because of Test Employee I
Test | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  | highlighted because of Test Employee I
Test | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  | highlighted because of Test Employee I
Test | Q |  |  |  |  |  |  |  |  | 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
Test | R |  |  |  | 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 |  | highlighted because of Test Employee L and N
Test | S |  |  |  |  |  |  | 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 |  | highlighted because of Test Employee R
Test | T |  |  |  |  |  |  | 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 |  | highlighted because of Test Employee R
Test | U |  |  |  | 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 |  | highlighted because of Test Employee R
Test | V |  |  |  | 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 | W |  |  |  |  |  |  |  | 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 | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  | highlighted because of Test Employee R
Test | Y |  |  |  |  |  |  |  |  |  | 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 |  | highlighted because of Test Employee R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no | 2020-07-17 00:00:00 |  |  | passive | 2020-07-20 00:00:00 | 2020-07-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no | 2020-07-11 00:00:00 |  |  | passive | 2020-07-20 00:00:00 | 2020-07-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No | 2020-07-01 00:00:00 |  |  | passive | 2020-07-02 00:00:00 | 2020-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No | 2020-07-01 00:00:00 |  |  | passive | 2020-07-02 00:00:00 | 2020-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | N/A |  |  | passive | 2020-07-20 00:00:00 | 2020-07-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | N/A |  |  | passive | 2020-07-20 00:00:00 | 2020-07-16 00:00:00