Spreadsheet: 325723d1402944995-conditional-formatting-across-multiple-spreadsheets-test
Sheet: Attendance

Employee Name | ID Number | Start Time
Emp 1 | 1 | 08:00:00 | P | P | OFF | P | VA | P | P | CI | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | LA | OFF | P | P | P | P | P | OFF | P | P | LA | P | P | OFF | P | P | P | P | P | OFF | P | P | P | CI | CI | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | LA | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | LA | P | P | OFF | P
Emp 2 |  | 10:30:00 | OFF | CI | OFF | P | P | P | P | P | P | P | P | P | OFF | P | OFF | OFF | P | P | P | P | P | P | P | P | OFF | P | OFF | P | P | P | LA | P | OFF | P | P | P | OFF | LA | P | OFF | P | P | P | P | P | CI | P | P | OFF | P | OFF | P | P | P | P | P | P | P | P | LA | OFF | P | OFF | P | P | P | P | P | P | P | P | P | OFF | P | OFF | P | P | P | P | P | P | P | P | P | OFF | P | OFF | P | P | P | P | P | P | P | P | P | P | P | P | P | VA | VA | OFF | VA | VA | VA | VA | P | P | P | OFF | P | P | P | P | P | P | CI | P | P | OFF | P | OFF | OFF | P | P | P | P | P | P | P | P | OFF | P | OFF | LA | P | P | P | P | P | P
Emp 3 |  | 08:00:00 | P | P | OFF | P | CI | NCNS | CI | VA | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | OFF | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | VA | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | VA | OFF | LA | LA | P | P | P | P | P | P | P | P | P | OFF | P | P | P | P | LA | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | LA | P | P | P | OFF | OFF | P | CI | P | P | P | OFF | OFF | P | P | VA | VA | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P
Emp 4 |  | 08:30:00 | CI | P | OFF | P | P | P | P | LA | P | P | P | P | P | P | OFF | P | P | P | P | P | LA | P | VA | P | P | OFF | OFF | P | P | CI | P | LA | P | P | P | LA | P | OFF | OFF | OFF | P | P | P | P | P | P | P | P | P | OFF | OFF | P | P | P | P | P | LA | P | P | P | LA | OFF | OFF | P | P | P | P | P | LA | P | P | P | P | OFF | OFF | P | P | P | P | P | VA | P | P | P | P | OFF | OFF | VA | VA | CI | P | P | LA | P | P | P | P | OFF | OFF | P | P | P | P | CI | P | P | P | P | VA | OFF | OFF | P | LA | P | P | P | P | P | P | P | P | OFF | OFF | OFF | P | P | CI | CI | OFF | P | P | LOW | P | OFF | OFF | P | P | P | CI | NLE | NLE | NLE
Emp 5 |  | 09:00:00 | CI | P | P | P | OFF | P | P | P | OFF | P | P | P | P | P | P | P | OFF | P | P | P | OFF | P | P | P | P | P | P | P | P | P | P | P | OFF | LA | P | P | P | P | P | P | OFF | P | P | P | OFF | P | P | P | P | P | P | P | OFF | P | P | P | OFF | P | P | P | P | P | P | P | OFF | P | P | P | OFF | P | P | P | P | P | P | P | P | P | P | P | OFF | P | P | P | P | P | P | OFF | OFF | P | P | P | OFF | P | P | P | P | P | P | P | OFF | P | P | P | OFF | P | P | P | VA | P | P | P | OFF | P | P | P | OFF | P | P | P | P | P | P | P | OFF | P | P | P | OFF | P | P | P | P | P | P | P | P | P | P | P | OFF | LA
Emp 6 |  | 08:00:00 | LA | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | LA | P | P | OFF | P | P | P | P | LA | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | VA | P | P | P | P | OFF | P | P | VA | P | VA | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | VA | LA | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | OFF | P | P | P | P | OFF | LA | P | P | P | P | OFF | CI | P | VA | P | LA | OFF | P
Emp 7 |  | 09:00:00 | OFF | P | LE | P | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | LA | P | P | P | OFF | P | LA | P | P | P | OFF | P | P | P | LA | P | OFF | P | LA | OFF | P | P | OFF | P | P | P | P | P | OFF | P | LA | P | P | P | OFF | P | OFF | P | P | P | P | P | P | P | P | P | OFF | P | VA | P | P | P | P | P | LA | P | P | P | OFF | P | LA | P | P | P | OFF | P | P | P | P | P | OFF | P | CI | P | P | P | OFF | P | P | P | P | P | OFF | P | LA | P | P | P | P | P | LA | LA | P | P | OFF | P | P | P | P | P | OFF | VA | VA | OFF | P | P | OFF | P | P | P | P | P | OFF | P | P | P | P | P | OFF | P | CI | P
Key- | 2014 Holidays
P - Present | 2014-01-01 00:00:00 | New Year's Day
CI- Called In | 2014-07-04 00:00:00 | Independence Day
ALA- Approved Late Arrival | 2014-09-01 00:00:00 | Labor Day
LA- Late Arrival | 2014-11-27 00:00:00 | Thanksgiving
NC/NS- No Call/ No Show | 2014-12-25 00:00:00 | Christmas
SLE - Scheduled Leave Early
ULE - Unscheduled Leave Early
LOW - Lack of Work
OFF - Scheduled Day Off
VA - Vacation Day