Spreadsheet: 34083d1231194619-conditional-formatting-sample
Sheet: Sheet1

NAME: |  |  |  |  |  |  |  |  |  |  | SSN: |  | XXX-XX-0555 |  |  |  |  |  | DOB: |  | 1968-08-12 00:00:00 |  |  |  | DOE: |  | 1994-03-07 00:00:00 |  |  | EARNS: | 15.96 | VAC
2009 RECORD OF TIME
PAY PERIOD |  | SAT |  | SUN |  | MON |  | TUE |  | WED |  | THU |  | FRI |  | SAT |  | SUN |  | MON |  | TUE |  | WED |  | THU |  | FRI |  | VAC | SICK | HOT
01/03 - 01/16 | * | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16
 |  | OD |  |  |  |  |  | SE |  |  |  |  |  | 24 |  |  |  |  |  | 24 |  |  |  |  |  | 24
01/17 - 01/30 |  | 17 |  | 18 |  | 19 | HD | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30
 |  |  |  | 24 |  |  |  |  |  | 24 |  |  |  |  |  | 24 |  |  |  |  |  | 24 |  |  |  |  |  | OD
01/31 - 02/13 |  | 31 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13
 |  |  |  |  |  | SF
02/14 - 02/27 | * | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27
02/28 - 03/13 |  | 28 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13
 |  |  |  |  |  |  |  |  |  | VAC
03/14 - 03/27 | * | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27
03/28 - 04/10 |  | 28 |  | 29 |  | 30 |  | 31 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 | HD
 |  |  |  |  |  |  |  |  |  |  |  |  |  | HOT
04/11 - 04/24 | * | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24
04/25 - 05/08 |  | 25 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8
05/09 - 05/22 | * | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22
05/23 - 06/05 |  | 23 |  | 24 |  | 25 | HD | 26 |  | 27 |  | 28 |  | 29 |  | 30 |  | 31 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5
06/06 - 06/19 | * | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19
06/20 - 07/03 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30 |  | 1 |  | 2 |  | 3 | HD
* ADD SICK LEAVE AND VACATION EARNED AT THE END OF THIS PAY PERIOD.         HD = HOLIDAY
REMARKS:
NAME: |  |  |  |  |  |  |  |  |  |  | SSN: |  | XXX-XX-0555 |  |  |  |  |  | DOB: |  | 1968-08-12 00:00:00 |  |  |  | DOE: |  | 1994-03-07 00:00:00 |  |  | EARNS: |  | VAC
2009 RECORD OF TIME
PAY PERIOD |  | SAT |  | SUN |  | MON |  | TUE |  | WED |  | THU |  | FRI |  | SAT |  | SUN |  | MON |  | TUE |  | WED |  | THU |  | FRI |  | VAC | SICK | HOT
07/04 - 07/17 | * | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17
07/18 - 07/31 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30 |  | 31
08/01 - 08/14 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 | HD | 13 |  | 14
08/15 - 08/28 | * | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28
08/29 - 09/11 |  | 29 |  | 30 |  | 31 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 | HD | 8 |  | 9 |  | 10 |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sf
09/12 - 09/25 | * | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25
09/26 - 10/09 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9
10/10 - 10/23 | * | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23
10/24 - 11/06 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30 |  | 31 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6
11/07 - 11/20 | * | 7 |  | 8 |  | 9 |  | 10 |  | 11 | HD | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20
11/21 - 12/04 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 | HD | 27 | HD | 28 |  | 29 |  | 30 |  | 1 |  | 2 |  | 3 |  | 4
12/05 - 12/18 | * | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18
12/19 - 01/01 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 | HD | 25 | HD | 26 |  | 27 |  | 28 |  | 29 |  | 39 |  | 31 |  | 1 | HD
* ADD SICK LEAVE AND VACATION EARNED AT THE END OF THIS PAY PERIOD.         HD = HOLIDAY
REMARKS: