Spreadsheet: 833179d1686827746-conditional-formatting-where-multiple-cells-are-not-blank-new-staff-2023-test
Sheet: HCP and Trainee EMDs

Name | ACC | HCP Start Date | Added to AQUA | Job Description | Emergency Mentor Period Start Date | Mentoring With | 1st Review Date | 2nd Review Date (if applicable | Audit 1 | Audit 2 | Audit 3 | Audit 4 | Emergency Mentor period End Date
 | North | 2023-04-14 00:00:00 | Yes | HCP EMD |  |  |  |  | X MH
 | West | 2022-07-11 00:00:00 | Yes | Trainee EMD | 2023-05-22 00:00:00 |  | 2023-06-16 00:00:00 |  | XAB | XAB | XAB | XB |  |  | Mentor Period Complete
 | North | 2023-04-28 00:00:00 | Yes | HCP EMD |  |  |  |  |  |  |  |  |  |  | Review within 14 days
 | East | 2023-04-14 00:00:00 | Yes | HCP EMD
 | West | 2022-08-22 00:00:00 | Yes | HCP EMD
 | East | 2022-05-09 00:00:00 | Yes | Trainee EMD | 2023-05-22 00:00:00 |  | 2023-06-17 00:00:00
 | East | 2022-05-09 00:00:00 | Yes | Trainee EMD | 2023-05-22 00:00:00 |  | 2023-06-17 00:00:00
 | West | 2022-10-24 00:00:00 | Yes | HCP EMD
 | North | 2023-04-28 00:00:00 | Yes | HCP EMD
 | East | 2022-08-15 00:00:00 | Yes | Trainee EMD | 2023-05-22 00:00:00 |  | 2023-06-18 00:00:00 |  | X | XAB
 | East | 2022-08-08 00:00:00 | Yes | Trainee EMD | 2023-05-22 00:00:00 |  | 2023-06-20 00:00:00
 | East | 2023-04-14 00:00:00 | Yes | HCP EMD
 | East | 2022-08-08 00:00:00 | Yes | Trainee EMD | 2023-05-22 00:00:00 |  | 2023-06-21 00:00:00
 | West | 2022-10-24 00:00:00 | Yes | HCP EMD
 | East | 2023-03-17 00:00:00 | Yes | HCP EMD
 | West | 2022-07-11 00:00:00 | Yes | HCP EMD
 | West | 2022-08-22 00:00:00 | Yes | Trainee EMD | 2023-05-22 00:00:00 |  | 2023-06-23 00:00:00 |  | X
 | North | 2023-04-28 00:00:00 | Yes | HCP EMD
 | East | 2022-05-09 00:00:00 | Yes | Trainee EMD | 2023-05-22 00:00:00 |  | 2023-06-25 00:00:00 |  | X | XAB
 | East | 2022-08-22 00:00:00 | Yes | HCP EMD
 | North | 2023-04-28 00:00:00 | Yes | HCP EMD
 | East | 2022-07-11 00:00:00 | Yes | Trainee EMD | 2023-06-10 00:00:00 |  | 2023-07-05 00:00:00
 | North | 2023-04-14 00:00:00 | Yes | HCP EMD
 | East | 2022-07-11 00:00:00 | Yes | Trainee EMD | 2023-06-14 00:00:00 |  | 2023-07-06 00:00:00
 | West | 2022-10-24 00:00:00 | Yes | HCP EMD
 | North | 2021-11-10 00:00:00 | Yes | Trainee EMD | N/A |  | Mat leave til 10/23
 | West | 2022-09-05 00:00:00 | Yes | Trainee EMD | N/A |  | [NAME] till 12/23
 | East | 2023-03-17 00:00:00 | Yes | HCP EMD
 | West | 2022-10-24 00:00:00 | Yes | HCP EMD
 | East | 2022-05-09 00:00:00 | Yes | HCP EMD
 | West | 2022-07-11 00:00:00 | Yes | Trainee EMD | 2023-05-22 00:00:00 |  | Off Sick
 | North | 2023-04-14 00:00:00 | Yes | HCP EMD
 | West | 2023-04-14 00:00:00 | Yes | Trainee EMD | 2023-06-10 00:00:00 |  | TBC
 | West | 2022-07-11 00:00:00 | Yes | HCP EMD
 | East | 2022-07-11 00:00:00 | Yes | Trainee EMD | 2023-06-10 00:00:00 |  | TBC
 | North | 2023-04-28 00:00:00 | No | HCP EMD
 | West | 2022-07-11 00:00:00 | Yes | Trainee EMD | 2023-05-22 00:00:00 |  | TBC |  | X PR | XAB | XAB
 | East | 2022-07-25 00:00:00 | Yes | HCP EMD
 | West | 2022-07-11 00:00:00 | Yes | Trainee EMD | 2023-06-10 00:00:00 |  | TBC
 | East | 2023-03-17 00:00:00 | Yes | HCP EMD
 | East | 2023-03-17 00:00:00 | Yes | HCP EMD
 | East | 2023-03-17 00:00:00 | Yes | HCP EMD