Spreadsheet: 78665d1279017425-conditional-date-formatting-due-date
Sheet: Sheet1

Due Date | Today | Data | Data | Data | Data | highlight
2010-05-01 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 73
2010-05-02 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 72
2010-05-03 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 71
2010-05-04 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 70
2010-05-05 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 69
2010-05-06 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 68
2010-05-07 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 67
2010-05-08 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 66
2010-05-09 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 65
2010-05-10 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 64
2010-05-11 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 63
2010-05-12 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 62
2010-05-13 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 61
2010-05-14 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 60
2010-05-15 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 59
2010-05-16 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 58
2010-05-17 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 57
2010-05-18 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 56
2010-05-19 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 55
2010-05-20 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 54
2010-05-21 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 53
2010-05-22 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 52
2010-05-23 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 51
2010-05-24 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 50
2010-05-25 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 49
2010-05-26 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 48
2010-05-27 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 47
2010-05-28 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 46
2010-05-29 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 45
2010-05-30 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 44
2010-05-31 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 43
2010-06-01 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 42
2010-06-02 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 41
2010-06-03 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 40
2010-06-04 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 39
2010-06-05 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 38
2010-06-06 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 37
2010-06-07 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 36
2010-06-08 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 35
2010-06-09 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 34
2010-06-10 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 33
2010-06-11 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 32
2010-06-12 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 31
2010-06-13 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 30
2010-06-14 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 29
2010-06-15 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 28
2010-06-16 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 27
2010-06-17 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 26
2010-06-18 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 25
2010-06-19 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 24
2010-06-20 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 23
2010-06-21 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 22
2010-06-22 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 21
2010-06-23 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 20
2010-06-24 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 19
2010-06-25 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 18
2010-06-26 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 17
2010-06-27 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 16
2010-06-28 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 15
2010-06-29 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 14
2010-06-30 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 13
2010-07-01 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 12
2010-07-02 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 11
2010-07-03 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 10
2010-07-04 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 9
2010-07-05 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 8
2010-07-06 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 7
2010-07-07 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 6
2010-07-08 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 5
2010-07-09 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 4
2010-07-10 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 3
2010-07-11 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 2
2010-07-12 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 1
2010-07-13 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | 0
2010-07-14 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | -1
2010-07-15 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | -2
2010-07-16 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | -3
2010-07-17 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | -4
2010-07-18 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | -5
2010-07-19 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | -6
2010-07-20 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | -7
2010-07-21 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | -8
2010-07-22 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | -9
2010-07-23 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | -10
2010-07-24 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | -11
2010-07-25 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | -12
2010-07-26 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | -13
2010-07-27 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | -14
2010-07-28 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | -15
2010-07-29 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | -16
2010-07-30 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | -17
2010-07-31 00:00:00 | 2010-07-13 00:00:00 |  |  |  |  | -18