Spreadsheet: 164652d1340827317-conditional-formatting-that-will-reference-entire-table-not-just-first-row-schedule
Sheet: Sheet1

Schedule (May 2012-2013) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 2
Group | 2012-05-11 00:00:00 | 2012-05-21 00:00:00 | 2012-06-01 00:00:00 | 2012-06-11 00:00:00 | 2012-06-21 00:00:00 | 2012-07-01 00:00:00 | 2012-07-11 00:00:00 | 2012-07-21 00:00:00 | 2012-08-01 00:00:00 | 2012-08-11 00:00:00 | 2012-08-21 00:00:00 | 2012-09-01 00:00:00 | 2012-09-11 00:00:00 | 2012-09-21 00:00:00 | 2012-10-01 00:00:00 | 2012-10-11 00:00:00 | 2012-10-21 00:00:00 | 2012-11-01 00:00:00 | 2012-11-11 00:00:00 | 2012-11-21 00:00:00 | 2012-12-01 00:00:00 | 2012-12-11 00:00:00 | 2012-12-21 00:00:00 | 2013-01-01 00:00:00 | 2013-01-11 00:00:00 | 2013-01-21 00:00:00 | 2013-02-01 00:00:00 | 2013-02-11 00:00:00 | 2013-02-21 00:00:00 | 2013-03-01 00:00:00 | 2013-03-11 00:00:00 | 2013-03-21 00:00:00 | 2013-04-01 00:00:00 | 2013-04-11 00:00:00 | 2013-04-21 00:00:00 | 2013-05-01 00:00:00 | 2013-05-11 00:00:00 | Item | Start | Completion | Area | Item | Start | Completion | Area
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | apple | 2012-06-05 00:00:00 | 2012-07-07 00:00:00 | N Clarksburg | chair | 2012-06-19 00:00:00 | 2012-07-22 00:00:00 | S Clarksburg
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | banana | 2012-07-07 00:00:00 | 2012-08-11 00:00:00 | S Clarksburg | tissue | 2012-07-22 00:00:00 | 2012-08-22 00:00:00 | S Clarksburg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cherry | 2012-08-11 00:00:00 |  | Tichenal | desk | 2012-08-22 00:00:00 | 2012-09-28 00:00:00 | S Clarksburg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | lime | 2012-09-22 00:00:00 |  | Tichenal | rock | 2012-09-28 00:00:00 | 2012-11-07 00:00:00 | S Clarksburg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | lemon | 2012-10-27 00:00:00 |  | Mountain | paper | 2012-11-07 00:00:00 | 2012-12-10 00:00:00 | S Clarksburg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pear | 2012-12-04 00:00:00 |  | S Clarksburg | keys | 2012-12-10 00:00:00 | 2013-01-17 00:00:00 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | orange | 2013-01-13 00:00:00 |  | S Clarksburg | watch | 2013-01-17 00:00:00 | 2013-02-15 00:00:00 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | nectarine | 2013-02-14 00:00:00 |  | North Canton | glass | 2013-02-15 00:00:00 | 2013-03-15 00:00:00 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | plum | 2013-03-19 00:00:00 |  | North Canton | phone | 2013-03-15 00:00:00 | 2013-04-11 00:00:00 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | peach | 2013-04-21 00:00:00 |  | North Canton | pen | 2013-04-11 00:00:00 | 2013-05-19 00:00:00 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mango | 2013-05-17 00:00:00 |  | North Canton | marker | 2013-05-19 00:00:00 | 2013-06-19 00:00:00 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2013-06-12 00:00:00 |  | Tichenal | computer | 2013-06-19 00:00:00 | 2013-07-17 00:00:00 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | papaya | 2013-07-19 00:00:00 |  | Tichenal | map | 2013-07-17 00:00:00 | 2013-08-14 00:00:00 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | prune | 2013-08-19 00:00:00 | 2013-09-19 00:00:00 | Tichenal | tea | 2013-08-14 00:00:00 |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Key
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Tichenal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | North Canton |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | South Canton |  | West Union
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N Clarksburg |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S Clarksburg |  | Ohio
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Salem |  | Mountain