Spreadsheet: 823303d1679890232-highlight-consecutive-cells-with-same-data-based-on-criteria-fatigue-hrs
Sheet: Old

 | LAST NAME, First Name
 |  |  | Midnight |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11 |  |  |  | Noon |  |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11
 | 2023-01-24 00:00:00 |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00
 | Work time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  |  | x | x | x | x | x | x | x | x | x | x | x | x |  |  | x | x | x | x |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 | Breaks |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x |  |  |  |  |  |  |  |  |  |  |  |  | x | x |  |  |  |  | x | x | x | x
 | Non-Work time |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x
 |  |  | Midnight |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11 |  |  |  | Noon |  |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11
 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00
 | Work time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  |  | x | x | x | x | x | x | x | x | x | x
 | Breaks |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x
 | Non-Work time |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  | Midnight |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11 |  |  |  | Noon |  |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11
 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00
 | Work time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  |  | x | x | x | x | x |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 | Breaks |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x |  |  |  |  |  | x | x | x | x | x | x | x | x
 | Non-Work time |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  | Midnight |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11 |  |  |  | Noon |  |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11
 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00
 | Work time |  | x | x | x | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  |  | x | x | x | x | x | x
 | Breaks |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x
 | Non-Work time |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  | Midnight |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11 |  |  |  | Noon |  |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11
 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00
 | Work time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 | Breaks
 | Non-Work time
 |  |  | Midnight |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11 |  |  |  | Noon |  |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11
 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00
 | Work time
 | Breaks
 | Non-Work time
 |  |  | Midnight |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11 |  |  |  | Noon |  |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11
 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00
 | Work time
 | Breaks
 | Non-Work time
 |  |  | Midnight |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11 |  |  |  | Noon |  |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11
 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00
 | Work time
 | Breaks
 | Non-Work time
 |  |  | Midnight |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11 |  |  |  | Noon |  |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11
 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00
 | Work time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  |  | x | x | x | x | x | x | x | x | x | x | x | x |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 | Breaks |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x |  |  |  |  |  |  |  |  |  |  |  |  | x | x
 | Non-Work time |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  | Midnight |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11 |  |  |  | Noon |  |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11
 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00
 | Work time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  |  | x | x | x | x | x | x | x | x |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 | Breaks |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x |  |  |  |  |  |  |  |  | x | x
 | Non-Work time |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  | Midnight |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11 |  |  |  | Noon |  |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11
 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00
 | Work time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  |  | x | x | x | x | x | x |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 | Breaks |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x |  |  |  |  |  |  | x | x
 | Non-Work time |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 |  |  | Midnight |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11 |  |  |  | Noon |  |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  | 11
 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00 |  |  |  | 12:30:00 |  |  |  | 01:30:00 |  |  |  | 02:30:00 |  |  |  | 03:30:00 |  |  |  | 04:30:00 |  |  |  | 05:30:00 |  |  |  | 06:30:00 |  |  |  | 07:30:00 |  |  |  | 08:30:00 |  |  |  | 09:30:00 |  |  |  | 10:30:00 |  |  |  | 11:30:00
 | Work time
 | Breaks
 | Non-Work time
 |  |  | Highlight consecutive cells with same data based on criteria
 |  |  | Is there a way to highlight cells that consecutively contain the same data, but only if the data is entered across 20 columns consecutively?
 |  |  | We have to track driver hours to ensure they are taking a break after 5 hours of driving. We have a spreadsheet that our admins use to assist with monitoring but it requires them to enter an 'x' in each column for hours worked, breaks and non-drive time. I want the 'Work time' rows to automatically highlight if more than 5hrs (20 columns) have an 'x' inputted so they don't have to go back and manually count each entry.
 |  |  | I've attached an example spreadsheet. You can see in row 5 that the driver worked 5.5hrs before taking a break, in this instance we would want columns AF-BA to be highlighted, or if its easier, columns AZ-BA as it still shows that the driver exceeded the allowable work hours. Is this possible?