Spreadsheet: 167272d1341940339-changing-a-cells-background-colour-based-on-a-form-entry-templateexample
Sheet: Time Sheet

 | August |  |  | Time |  |  | Wed |  | Thu |  | Fri |  | Sat |  | Sun |  | Mon |  | Tue |  | Time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Time
 |  |  |  |  |  |  | 2012-08-01 00:00:00
 |  |  |  | 07:00:00 | - | 07:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | - | 07:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | - | 07:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | - | 07:30:00
 |  |  |  | 07:30:00 | - | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 | - | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 | - | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 | - | 08:00:00
 | Name1 | 0 |  | 08:00:00 | - | 08:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00 | - | 08:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00 | - | 08:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00 | - | 08:30:00
 |  |  |  | 08:30:00 | - | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:30:00 | - | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:30:00 | - | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:30:00 | - | 09:00:00
 | [NAME] | 0 |  | 09:00:00 | - | 09:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00 | - | 09:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00 | - | 09:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00 | - | 09:30:00
 |  |  |  | 09:30:00 | - | 10:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:30:00 | - | 10:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:30:00 | - | 10:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:30:00 | - | 10:00:00
 | Name3 | 0 |  | 10:00:00 | - | 10:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 | - | 10:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 | - | 10:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 | - | 10:30:00
 |  |  |  | 10:30:00 | - | 11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:30:00 | - | 11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:30:00 | - | 11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:30:00 | - | 11:00:00
 | Name4 | 0 |  | 11:00:00 | - | 11:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:00:00 | - | 11:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:00:00 | - | 11:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:00:00 | - | 11:30:00
 |  |  |  | 11:30:00 | - | 12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:30:00 | - | 12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:30:00 | - | 12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:30:00 | - | 12:00:00
 | Name5 | 0 |  | 12:00:00 | - | 12:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 | - | 12:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 | - | 12:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 | - | 12:30:00
 |  |  |  | 12:30:00 | - | 13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:30:00 | - | 13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:30:00 | - | 13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:30:00 | - | 13:00:00
 | Name6 | 0 |  | 13:00:00 | - | 13:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00 | - | 13:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00 | - | 13:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00 | - | 13:30:00
 |  |  |  | 13:30:00 | - | 14:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:30:00 | - | 14:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:30:00 | - | 14:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:30:00 | - | 14:00:00
 | Total |  |  | 14:00:00 | - | 14:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 | - | 14:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 | - | 14:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 | - | 14:30:00
 |  |  |  | 14:30:00 | - | 15:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:30:00 | - | 15:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:30:00 | - | 15:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:30:00 | - | 15:00:00
 |  |  |  | 15:00:00 | - | 15:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00 | - | 15:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00 | - | 15:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00 | - | 15:30:00
 |  |  |  | 15:30:00 | - | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00 | - | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00 | - | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00 | - | 16:00:00
 |  |  |  | 16:00:00 | - | 16:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:00:00 | - | 16:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:00:00 | - | 16:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:00:00 | - | 16:30:00
 |  |  |  | 16:30:00 | - | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:30:00 | - | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:30:00 | - | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:30:00 | - | 17:00:00
 |  |  |  | 17:00:00 | - | 17:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:00:00 | - | 17:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:00:00 | - | 17:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:00:00 | - | 17:30:00
 |  |  |  | 17:30:00 | - | 18:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:30:00 | - | 18:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:30:00 | - | 18:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:30:00 | - | 18:00:00
 |  |  |  | 18:00:00 | - | 18:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00 | - | 18:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00 | - | 18:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00 | - | 18:30:00
 |  |  |  | 18:30:00 | - | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:30:00 | - | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:30:00 | - | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:30:00 | - | 19:00:00
 |  |  |  | 19:00:00 | - | 19:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00 | - | 19:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00 | - | 19:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00 | - | 19:30:00
 |  |  |  | 19:30:00 | - | 20:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:30:00 | - | 20:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:30:00 | - | 20:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:30:00 | - | 20:00:00
 |  |  |  | 20:00:00 | - | 20:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:00:00 | - | 20:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:00:00 | - | 20:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:00:00 | - | 20:30:00
 |  |  |  | 20:30:00 | - | 21:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:30:00 | - | 21:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:30:00 | - | 21:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:30:00 | - | 21:00:00
 |  |  |  | 21:00:00 | - | 21:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:00:00 | - | 21:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:00:00 | - | 21:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:00:00 | - | 21:30:00
 |  |  |  | 21:30:00 | - | 22:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:30:00 | - | 22:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:30:00 | - | 22:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:30:00 | - | 22:00:00