Spreadsheet: 270080d1381364390-conditional-formatting-example
Sheet: Sheet1

 | October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sexual Assault |  |  |  | Self Defense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff Meeting
 | Employee Name | Available Hours Beginning of Month | HR Hours Report Comparison | This Month's Hours | BackFill Hours | Drop-off Hours | Available Hours End of Month | Correction Hours |  | 2013-10-01 00:00:00 |  | 2013-10-02 00:00:00 |  | 2013-10-03 00:00:00 |  | 2013-10-04 00:00:00 |  | 2013-10-05 00:00:00 |  | 2013-10-06 00:00:00 |  | 2013-10-07 00:00:00 |  | 2013-10-08 00:00:00 |  | 2013-10-09 00:00:00 |  | 2013-10-10 00:00:00 |  | 2013-10-11 00:00:00 |  | 2013-10-12 00:00:00 |  | 2013-10-13 00:00:00 |  | 2013-10-14 00:00:00 |  | 2013-10-15 00:00:00 |  | 2013-10-16 00:00:00 |  | 2013-10-17 00:00:00 |  | 2013-10-18 00:00:00 |  | 2013-10-19 00:00:00 |  | 2013-10-20 00:00:00 |  | 2013-10-21 00:00:00 |  | 2013-10-22 00:00:00 |  | 2013-10-23 00:00:00 |  | 2013-10-24 00:00:00 |  | 2013-10-25 00:00:00 |  | 2013-10-26 00:00:00 |  | 2013-10-27 00:00:00 |  | 2013-10-28 00:00:00 |  | 2013-10-29 00:00:00 |  | 2013-10-30 00:00:00 |  | 2013-10-31 00:00:00
 |  |  |  |  |  |  |  |  |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift |  | Shift
 |  |  |  |  |  |  |  |  |  | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End
O | Bower |  |  |  |  |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  | 8:00:00 | 16:00:00 | 13:00:00 | 15:00:00 |  |  |  |  |  |  |  |  |  |  | 8:00:00 | 16:00:00 | 13:00:00 | 15:00:00 |  |  |  |  |  |  |  |  |  |  | 8:00:00 | 16:00:00 | 13:00:00 | 15:00:00 |  |  |  |  |  |  |  |  |  |  | 8:00:00 | 16:00:00 | 13:00:00 | 15:00:00
 |  |  |  |  |  |  |  |  | BackFill Hours
 | Payroll Hours
O | Bradley |  |  |  |  |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0:00:00 | 8:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0:00:00 | 8:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0:00:00 | 8:00:00
 |  |  |  |  |  |  |  |  | BackFill Hours
 | Payroll Hours
O | Clements |  |  |  |  |  |  |  | Hours | 7:00:00 | 17:00:00 |  |  |  |  | 8:00:00 | 16:00:00 |  |  |  |  |  |  |  |  | 11:30:00 | 14:30:00 |  |  | 8:00:00 | 16:00:00 |  |  |  |  |  |  | 15:00:00 | 17:00:00 |  |  |  |  | 8:00:00 | 16:00:00 |  |  |  |  | 8:00:00 | 16:00:00 | 15:00:00 | 17:00:00 | 16:00:00 | 1 day, 0:00:00 | 16:00:00 | 1 day, 0:00:00 | 8:00:00 | 16:00:00 |  |  |  |  |  |  | 15:00:00 | 1 day, 0:00:00 | 16:00:00 | 1 day, 0:00:00
 |  |  |  |  |  |  |  |  | BackFill Hours
 | Payroll Hours
O | Conway |  |  |  |  |  |  |  | Hours |  |  | 8:00:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:00:00 | 16:00:00 | 8:00:00 | 16:00:00
 |  |  |  |  |  |  |  |  | BackFill Hours
 | Payroll Hours
O | [NAME] |  |  |  |  |  |  |  | Hours
 |  |  |  |  |  |  |  |  | BackFill Hours
 | Payroll Hours
F | Hanneson |  |  |  |  |  |  |  | Hours | 0:00:00 | 8:00:00 | 0:00:00 | 8:00:00 | 0:00:00 | 8:00:00 | 0:00:00 | 8:00:00 | 0:00:00 | 8:00:00 |  |  |  |  | 0:00:00 | 8:00:00 | 0:00:00 | 8:00:00 | 0:00:00 | 8:00:00 | 0:00:00 | 8:00:00 |  |  |  |  |  |  | 0:00:00 | 8:00:00 | 0:00:00 | 8:00:00 | 0:00:00 | 8:00:00 | 0:00:00 | 8:00:00 |  |  |  |  |  |  | 0:00:00 | 8:00:00 | 0:00:00 | 8:00:00 | 0:00:00 | 8:00:00 | 0:00:00 | 8:00:00 |  |  |  |  |  |  | 0:00:00 | 8:00:00 | 0:00:00 | 8:00:00 | 0:00:00 | 8:00:00
 |  |  |  |  |  |  |  |  | BackFill Hours
 | Payroll Hours
F | [NAME] |  |  |  |  |  |  |  | Hours | 8:00:00 | 16:00:00 | 8:00:00 | 16:00:00 |  |  |  |  |  |  | 8:00:00 | 16:00:00 | 8:00:00 | 16:00:00 |  |  | 8:00:00 | 16:00:00 | 8:00:00 | 16:00:00 |  |  |  |  | 8:00:00 | 16:00:00 | 8:00:00 | 16:00:00 | 8:00:00 | 16:00:00 | 8:00:00 | 16:00:00 | 8:00:00 | 16:00:00 |  |  |  |  | 8:00:00 | 16:00:00 | 8:00:00 | 16:00:00 | 8:00:00 | 16:00:00 | 8:00:00 | 16:00:00 | 8:00:00 | 16:00:00 |  |  |  |  | 8:00:00 | 16:00:00 | 8:00:00 | 16:00:00 | 8:00:00 | 16:00:00 | 8:00:00 | 16:00:00 | 8:00:00 | 16:00:00
 |  |  |  |  |  |  |  |  | BackFill Hours
 | Payroll Hours
C | Herrera ( C ) |  |  |  |  |  |  |  | Hours | 8:00:00 | 16:00:00 | 8:00:00 | 16:00:00 | 8:00:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  | 16:00:00 | 1 day, 0:00:00 |  |  | 16:00:00 | 1 day, 0:00:00 | 16:00:00 | 1 day, 0:00:00 | 8:00:00 | 16:00:00 | 8:00:00 | 16:00:00 |  |  |  |  | 0:00:00 | 8:00:00 | 16:00:00 | 1 day, 0:00:00 |  |  |  |  |  |  |  |  |  |  | 0:00:00 | 8:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0:00:00 | 8:00:00
 |  |  |  |  |  |  |  |  | BackFill Hours
 | Payroll Hours