Spreadsheet: 273392d1382701955-lookup-date-and-condtional-format-colour-based-on-date-0a1_conditional-format-based-on-week-ending-2
Sheet: Sheet1

Date | Week Ending
2013-09-23 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-23 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-23 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-23 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-24 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-24 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-24 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-24 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-24 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-24 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-24 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-24 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-24 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-25 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-25 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-25 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-25 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-25 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-26 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-26 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-26 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-27 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-27 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-27 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-27 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-27 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-27 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-28 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-28 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-28 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-28 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-28 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-28 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-28 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-28 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-28 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-28 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-28 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-28 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-28 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-29 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-29 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-29 00:00:00 | 2013-09-29 00:00:00 | Colour cell based on week end date | 1
2013-09-30 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-09-30 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-09-30 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-09-30 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-09-30 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-09-30 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-01 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-01 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-01 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-01 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-01 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-01 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-01 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-01 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-01 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-02 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-02 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-02 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-03 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-03 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-03 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-03 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-03 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-03 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-03 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-04 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-04 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-04 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-04 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-04 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-04 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-06 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-06 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-06 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-06 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-06 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-06 00:00:00 | 2013-10-06 00:00:00 | Colour cell based on week end date | 2
2013-10-07 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-07 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-07 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-07 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-07 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-07 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-07 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-07 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-07 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-08 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-08 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-08 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-08 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-08 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-08 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-08 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-08 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-09 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-09 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-09 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-09 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-09 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-09 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-09 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-09 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-09 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-09 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-09 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-09 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-09 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-09 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-09 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-10 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-10 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-11 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-11 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-11 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-11 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-11 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-11 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-12 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-12 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-12 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-12 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-12 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-13 00:00:00 | 2013-10-13 00:00:00 | Colour cell based on week end date | 3
2013-10-14 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-14 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-14 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-14 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-14 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-15 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-15 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-15 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-15 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-15 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-15 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-15 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-16 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-16 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-16 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-16 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-16 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-16 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-16 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-16 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-16 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-16 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-17 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-17 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-17 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-17 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-17 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-17 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-18 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-18 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-18 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-18 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-19 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-19 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-19 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-19 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-19 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-19 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-19 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-19 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-19 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-19 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-19 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4
2013-10-19 00:00:00 | 2013-10-20 00:00:00 | Colour cell based on week end date | 4