Spreadsheet: 695771d1600389433-conditional-formatting-formula-for-multiple-conditions-matching-testconditional-format-5_revd
Sheet: Follow-Up Monitoring

Employee Monitoring for COVID 19 |  |  |  |  | Work Locations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee  Information |  |  |  |  | Household Information |  |  |  |  | Screen for Return to Work |  |  |  |  | EXPECTED HIGHLIGHTING
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 |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | Employee Test Date | Employee Result
Test | A |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-06-25 00:00:00 | negative |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | 2020-06-26 00:00:00 | positive
Test | C |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  | x |  |  |  |  | 2020-07-01 00:00:00 | positive |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | 2020-07-02 00:00:00 | negative
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) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | 2020-07-02 00:00:00 | negative
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | 2020-07-02 00:00:00 | negative
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | 2020-07-06 00:00:00 | negative
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 |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  | x | 2020-07-06 00:00:00 | negative
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 |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  | x |  |  | x | 2020-07-08 00:00:00 | positive
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | 2020-07-15 00:00:00 | negative
Test | L |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  | 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 |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  | x |  |  | 2020-07-15 00:00:00 | positive
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | 2020-07-15 00:00:00 | negative
Test | N |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  | x | 2020-07-17 00:00:00 | positive
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | 2020-07-17 00:00:00 | negative
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | 2020-07-20 00:00:00 | negative
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  | 2020-07-21 00:00:00 | negative
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 |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 2020-07-25 00:00:00 | positive
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 |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  | 2020-07-27 00:00:00 | negative
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 |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  | 2020-07-27 00:00:00 | negative
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 |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 2020-07-27 00:00:00 | negative
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 |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-28 00:00:00 | negative
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  | 2020-08-01 00:00:00 | negative
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | 2020-08-03 00:00:00 | positive
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x |  |  |  |  |  |  | 2020-08-03 00:00:00 | negative
NEW |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | No | 2020-07-20 00:00:00 | 2020-09-25 00:00:00 | positive | passive | 2020-07-02 00:00:00 | 2020-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | 2020-09-25 00:00:00 | positive
NEW |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | no | 44039 | 2020-09-27 00:00:00 | negative | passive | 2020-07-20 00:00:00 | 2020-07-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | 2020-09-27 00:00:00 | negative
NEW |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | no | 44042 | 2020-10-03 00:00:00 | positive |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | 2020-10-03 00:00:00 | positive
NEW |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | no | 44052 | 2020-10-10 00:00:00 | negative |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | 2020-10-10 00:00:00 | negative
NEW |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | no | 44052 | 2020-10-10 00:00:00 | positive |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | 2020-10-10 00:00:00 | positive