Spreadsheet: 816728d1675794674-conditional-formatting-based-on-two-cells-matching-using-a-different-range-year-planner-annual-leave-planner
Sheet: Schemes

Scheme name | Start date | End date | Provider
(ABC1) Scheme Level 3 | 2022-07-04 00:00:00 | 2023-10-03 00:00:00 | Provider 1 |  |  | L | R |  |  |  |  |  |  | L | R |  |  |  |  | L | R |  |  |  |  |  | L | R |  |  |  |  |  |  | R | E |  |  |  |  |  |  | E |  |  |  |  |  |  | E |  |  |  |  |  |  | E |  |  |  |  |  | L | R |  |  |  |  | L | R |  |  |  |  |  | L | R |  |  |  |  |  | L | R |  |  |  |  |  |  | R |  |  |  |  |  |  | R |  |  |  |  |  |  | R |  |  |  |  |  |  | R |  |  |  |  |  |  | R |  |  |  |  |  |  |  | R |  |  |  |  | L | R |  |  |  |  |  | L | R |  |  |  |  |  | L | R |  |  |  |  |  |  | L | R |  |  |  |  |  | E |  |  |  |  |  |  | E |  |  |  |  |  |  | E |  |  |  |  |  |  | E |  |  |  |  |  |  | E
(BCD2) Scheme Level 4 | 2022-07-04 00:00:00 | 2023-10-03 00:00:00 | Provider 2 |  |  |  |  | L | L |  |  |  |  |  |  | L | L |  |  |  |  |  | L | L |  |  |  |  |  | R | R |  |  |  |  |  | L | L |  |  |  |  |  | L | L |  |  |  |  |  | L | L |  |  |  |  |  | R | R |  |  |  |  |  | L | L |  |  |  |  |  | L | L |  |  |  |  |  | L | L |  |  |  |  |  | L | L |  |  |  |  |  | R | R |  |  |  |  |  | L | L |  |  |  |  |  | L | L |  |  |  |  |  | L | L |  |  |  |  |  | R | R |  |  |  |  |  | L | L |  |  |  |  |  | L | L |  |  |  |  |  | L | L |  |  |  |  |  | R | R |  |  |  |  |  | R | R |  |  |  |  |  | E | E |  |  |  |  |  | E | E |  |  |  |  |  | E | E |  |  |  |  |  | E | E |  |  | E | E
(CDE3) Scheme Level 5 | 2022-09-26 00:00:00 | 2024-01-28 00:00:00 | Provider 3 |  |  |  |  |  | R |  |  |  |  |  |  |  | R |  |  |  |  |  | R | L |  |  |  |  |  |  | R |  |  |  |  |  |  | R |  |  |  |  |  |  | R |  |  |  |  |  | L | R |  |  |  |  |  |  | R |  |  |  |  |  |  | R |  |  |  |  |  |  | R |  |  |  |  |  |  | R |  |  |  |  |  | L | R |  |  |  |  |  |  | R |  |  |  |  |  |  | R |  |  |  |  |  |  | R |  |  |  |  |  | L | R |  |  |  |  |  |  | R |  |  |  |  |  | L | R |  |  |  |  |  |  | R |  |  |  |  |  | L | R |  |  |  |  |  |  | R |  |  |  |  |  |  | R |  |  |  |  |  |  | R |  |  |  |  |  | L | R |  |  |  |  |  |  | R |  |  |  |  |  |  | R |  |  |  |  |  |  | R |  |  |  |  |  | L | R |  |  |  |  |  |  | R |  |  |  |  |  |  | R |  |  |  |  | L |  |  |  |  |  |  | L |  |  |  |  |  |  | L |  |  |  |  |  |  | E |  |  |  |  |  |  | E |  |  |  |  |  |  | E |  |  |  |  |  |  | E |  |  |  |  |  |  | E |  |  |  |  |  |  | E |  |  |  |  |  |  | E |  |  |  |  |  |  | R |  |  |  |  |  |  | R |  |  |  |  |  |  | R
(DEF4) Scheme Level 6 | 2022-07-04 00:00:00 | 2023-10-03 00:00:00 | Provider 2 |  |  |  |  | L | L |  |  |  |  |  |  | L | L |  |  |  |  |  | L | L |  |  |  |  |  | R | R |  |  |  |  |  | L | L |  |  |  |  |  | L | L |  |  |  |  |  | L | L |  |  |  |  |  | R | R |  |  |  |  |  | L | L |  |  |  |  |  | L | L |  |  |  |  |  | L | L |  |  |  |  |  | L | L |  |  |  |  |  | R | R |  |  |  |  |  | L | L |  |  |  |  |  | L | L |  |  |  |  |  | L | L |  |  |  |  |  | R | R |  |  |  |  |  | L | L |  |  |  |  |  | L | L |  |  |  |  |  | L | L |  |  |  |  |  | R | R |  |  |  |  |  | R | R |  |  |  |  |  | E | E |  |  |  |  |  | E | E |  |  |  |  |  | E | E |  |  |  |  |  | E | E |  |  | E | E
(EFG5) Scheme Level 4 | 2022-09-26 00:00:00 | 2024-05-26 00:00:00 | Provider 4 |  |  | L |  |  | R |  |  |  |  | R |  |  | R |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  |  | E |  |  |  |  |  |  | L |  |  | R |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  |  | E |  |  |  |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  | E |  |  |  |  |  |  | L |  |  |  | E |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  | E |  |  |  |  |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  |  | E |  |  |  |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  | E |  |  |  |  |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  | E |  |  |  |  |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  | E |  |  |  |  |  |  | L |  |  |  | E |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  |  |  | E |  |  |  |  |  | L |  |  | R |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  | E |  |  |  |  |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  | E |  |  |  |  |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  | L |  |  |  | R |  |  | E