Spreadsheet: 839282d1691782460-conditional-formatting-formula-on-multiple-rows-k-and-t-log-
Sheet: Paste

APT # | Last Name | First Name | Check In | Due Date | Base
A1006 | Doe 1 | [NAME] | 2023-05-27 00:00:00 | 2023-08-04 00:00:00 | 289
A1010 | Doe 2 | [NAME] | 2017-02-10 00:00:00 | 2023-08-04 00:00:00 | 309
A1012 | Doe 3 | [NAME] | 2019-11-14 00:00:00 | 2023-08-04 00:00:00 | 279
A2001 | Doe 4 | [NAME] | 2020-04-16 00:00:00 | 2023-08-04 00:00:00 | 249
A2005 | Doe 5 | [NAME] | 2017-07-08 00:00:00 | 2023-08-04 00:00:00 | 259
B1018 | Doe 6 | [NAME] | 2022-10-02 00:00:00 | 2023-08-04 00:00:00 | 329
B1021 | Doe 7 | [NAME] | 2023-03-31 00:00:00 | 2023-08-04 00:00:00 | 329
B1023 | Doe 8 | [NAME] | 2022-02-18 00:00:00 | 2023-08-04 00:00:00 | 319
B1025 | Doe 9 | [NAME] | 2021-08-18 00:00:00 | 2023-08-04 00:00:00 | 339
B1027 | Doe 10 | [NAME] 10 | 2020-08-14 00:00:00 | 2023-08-04 00:00:00 | 289
B2017 | Doe 11 | [NAME] | 2023-03-31 00:00:00 | 2023-08-04 00:00:00 | 309
B3019 | Doe 12 | [NAME] | 2022-09-01 00:00:00 | 2023-08-04 00:00:00 | 309
B3021 | Doe 13 | [NAME] | 2022-06-16 00:00:00 | 2023-08-04 00:00:00 | 329
C1034 | Doe 14 | [NAME] | 2010-08-11 00:00:00 | 2023-08-04 00:00:00 | 239
C1047 | Doe 15 | [NAME] 15 | 2017-11-02 00:00:00 | 2023-08-04 00:00:00 | 259
C2041 | Doe 16 | [NAME] | 2014-10-24 00:00:00 | 2023-08-04 00:00:00 | 239
C2042 | Doe 17 | [NAME] | 2022-04-01 00:00:00 | 2023-08-04 00:00:00 | 329
C3039 | Doe 18 | [NAME] | 2023-05-15 00:00:00 | 2023-08-04 00:00:00 | 319
D1054 | Doe 19 | [NAME] | 2015-06-24 00:00:00 | 2023-08-04 00:00:00 | 269
[NAME] | Doe 20 | [NAME] 20 | 2022-02-18 00:00:00 | 2023-08-04 00:00:00 | 329
D1058 | Doe 21 | [NAME] 21 | 2022-03-24 00:00:00 | 2023-08-04 00:00:00 | 349
D1059 | Doe 22 | [NAME] | 2022-02-11 00:00:00 | 2023-08-04 00:00:00 | 319
D3055 | Doe 23 | [NAME] 23 | 2021-12-01 00:00:00 | 2023-08-04 00:00:00 | 299
E1071 | Doe 24 | [NAME] | 2022-04-05 00:00:00 | 2023-08-04 00:00:00 | 349
E2066 | Doe 25 | [NAME] | 2023-06-02 00:00:00 | 2023-08-04 00:00:00 | 299
E2070 | Doe 26 | [NAME] 26 | 2017-11-05 00:00:00 | 2023-08-04 00:00:00 | 269
E3068 | Doe 27 | [NAME] | 2018-10-05 00:00:00 | 2023-08-04 00:00:00 | 269
F1073 | Doe 28 | [NAME] | 2023-07-14 00:00:00 | 2023-08-04 00:00:00 | 309
F1079 | Doe 29 | [NAME] 29 | 2023-03-23 00:00:00 | 2023-08-04 00:00:00 | 329
F2078 | Doe 30 | [NAME] 30 | 2022-06-03 00:00:00 | 2023-08-04 00:00:00 | 359
G1100 | Doe 31 | [NAME] | 2022-10-07 00:00:00 | 2023-08-04 00:00:00 | 309
G2092 | Doe 32 | [NAME] 32 | 2022-01-07 00:00:00 | 2023-08-04 00:00:00 | 319
G2095 | Doe 33 | [NAME] | 2023-06-02 00:00:00 | 2023-08-04 00:00:00 | 309
G2097 | Doe 34 | [NAME] 34 | 2023-01-06 00:00:00 | 2023-08-04 00:00:00 | 309
G3087 | Doe 35 | [NAME] | 2023-06-09 00:00:00 | 2023-08-04 00:00:00 | 329
G3091 | Doe 36 | [NAME] 36 | 2023-04-07 00:00:00 | 2023-08-04 00:00:00 | 309
H2106 | Doe 37 | [NAME] | 2023-06-09 00:00:00 | 2023-08-04 00:00:00 | 329
H3106 | Doe 38 | [NAME] 38 | 2023-07-07 00:00:00 | 2023-08-04 00:00:00 | 289
J1123 | Doe 39 | [NAME] | 2022-04-01 00:00:00 | 2023-08-04 00:00:00 | 409
J2121 | Doe 40 | [NAME] | 2021-03-25 00:00:00 | 2023-08-04 00:00:00 | 379
[NAME] | Doe 41 | [NAME] | 2017-09-13 00:00:00 | 2023-08-04 00:00:00 | 339
J3113 | Doe 42 | [NAME] | 2021-11-26 00:00:00 | 2023-08-04 00:00:00 | 419
J3114 | Doe 43 | [NAME] | 2021-10-25 00:00:00 | 2023-08-04 00:00:00 | 419
J3116 | Doe 44 | [NAME] | 2022-09-02 00:00:00 | 2023-08-04 00:00:00 | 409
J3126 | Doe 45 | [NAME] | 2021-11-12 00:00:00 | 2023-08-04 00:00:00 | 429
K1128 | Doe 46 | [NAME] | 2018-01-27 00:00:00 | 2023-08-04 00:00:00 | 329
K1133 | Doe 47 | [NAME] | 2019-04-04 00:00:00 | 2023-08-04 00:00:00 | 359
K2130 | Doe 48 | [NAME] | 2018-06-01 00:00:00 | 2023-08-04 00:00:00 | 339
K2136 | Doe 49 | [NAME] | 2018-09-21 00:00:00 | 2023-08-04 00:00:00 | 349
K3132 | Doe 50 | [NAME] 50 | 2022-10-14 00:00:00 | 2023-08-04 00:00:00 | 429
K3135 | Doe 51 | [NAME] | 2022-04-28 00:00:00 | 2023-08-04 00:00:00 | 489
L1137 | Doe 52 | [NAME] 52 | 2000-01-08 00:00:00 | 2023-08-04 00:00:00 | 249
L1145 | Doe 53 | [NAME] 53 | 2021-02-28 00:00:00 | 2023-08-04 00:00:00 | 299
[NAME] | Doe 54 | [NAME] | 2022-12-09 00:00:00 | 2023-08-04 00:00:00 | 299
M2152 | Doe 55 | [NAME] 55 | 2023-02-23 00:00:00 | 2023-08-04 00:00:00 | 309