Spreadsheet: 102939d1300818338-excel-2007-conditional-formatting-what-im-trying-to-do-is-all-dates-fofr-final-10-jun-2010
Sheet: Decal

Decal Issued | Date Decal Issued | Decal Number
Yes | 2009-08-31 00:00:00 | 1
Yes | 2009-09-03 00:00:00 | 2
Yes | 2009-09-16 00:00:00 | 3
Yes | 2009-09-24 00:00:00 | 4
Yes | 2009-09-29 00:00:00 | 5
Yes | 2009-10-02 00:00:00 | 6
Yes | 2009-10-06 00:00:00 | 7
Yes | 2009-10-10 00:00:00 | 8
Yes | 2009-10-10 00:00:00 | 9
Yes | 2009-10-19 00:00:00 | 10
Yes | 2009-11-05 00:00:00 | 11
Yes | 2009-11-05 00:00:00 | 12
Yes | 2009-12-01 00:00:00 | 13
Yes | 2009-12-21 00:00:00 | 14
Yes | 2009-12-21 00:00:00 | 15
Yes | 2009-12-23 00:00:00 | 16
Yes | 2010-01-21 00:00:00 | 17
Yes | 2010-01-26 00:00:00 | 18
Yes | 2010-01-28 00:00:00 | 19
Yes | 2010-02-11 00:00:00 | 20
Yes | 2010-02-23 00:00:00 | 21
Yes | 2010-02-23 00:00:00 | 22
Yes | 2010-02-24 00:00:00 | 23
Yes | 2010-03-09 00:00:00 | 24
Yes | 2010-03-10 00:00:00 | 25
Yes | 2010-03-10 00:00:00 | 26
Yes | 2010-03-18 00:00:00 | 27
Yes | 2010-03-30 00:00:00 | 28
Yes | 2010-04-12 00:00:00 | 29
Yes | 2010-04-15 00:00:00 | 30
Yes | 2010-05-05 00:00:00 | 31
Yes | 2010-05-13 00:00:00 | 32
Yes | 2010-05-13 00:00:00 | 33
Yes | 2010-05-14 00:00:00 | 34
Yes | 2010-05-21 00:00:00 | 35
Yes | 2010-05-21 00:00:00 | 36
Yes | 2010-05-21 00:00:00 | 37
Yes | 2010-05-21 00:00:00 | 38
Yes | 2010-05-21 00:00:00 | 39
Yes | 2010-05-21 00:00:00 | 40
Yes | 2010-05-21 00:00:00 | 41
Yes | 2010-06-09 00:00:00 | 42
Yes | 2010-05-26 00:00:00 | 43
yes | 2010-06-23 00:00:00 | 45
Yes | 2010-06-02 00:00:00 | 44
YES | 2010-07-01 00:00:00 | 47
Yes | 2010-07-09 00:00:00 | 48
Yes | 2010-06-29 00:00:00 | 46
Yes | 2010-07-20 00:00:00 | 49
Yes | 2010-07-29 00:00:00 | 51
Yes | 2010-07-20 00:00:00 | 50
Yes | 2010-08-02 00:00:00 | 52
Yes | 2010-08-31 00:00:00 | 54
Yes | 2010-08-24 00:00:00 | 53
Yes | 2010-09-02 00:00:00 | 56
Yes | 2010-08-31 00:00:00 | 55
Yes | 2010-09-09 00:00:00 | 58
Yes | 2010-09-09 00:00:00 | 59
Yes | 2010-09-21 00:00:00 | 60
Yes | 2010-09-10 00:00:00 | 57
Yes | 2010-09-20 00:00:00 | 62
Yes | 2010-09-27 00:00:00 | 63
Yes | 2010-09-28 00:00:00 | 64
Yes | 2010-09-30 00:00:00 | 65
Yes | 2010-09-09 00:00:00 | 61
Yes | 2010-09-30 00:00:00 | 66
Yes | 2010-09-30 00:00:00 | 67
yes | 2010-09-30 00:00:00 | 68
Yes | 2010-10-06 00:00:00 | 69
Yes | 2010-08-05 00:00:00 | 70
Yes | 2010-09-27 00:00:00 | 72
Yes | 2010-10-13 00:00:00 | 73
Yes | 2010-12-06 00:00:00 | 74
Yes | 2009-07-02 00:00:00 | P01
Yes | 2009-10-16 00:00:00 | P02
Yes | 2009-10-16 00:00:00 | P03
Yes | 2009-10-20 00:00:00 | P04
Yes | 2009-10-28 00:00:00 | P05
Yes | 2009-11-02 00:00:00 | P06
Yes | 2009-11-12 00:00:00 | P07
Yes | 2009-12-17 00:00:00 | P08
Yes | 2009-12-11 00:00:00 | P08
Yes | 2009-12-21 00:00:00 | P09
Yes | 2010-01-15 00:00:00 | P10
Yes | 2010-04-12 00:00:00 | P11
Yes | 2009-09-15 00:00:00 | Q01
Yes | 2010-01-13 00:00:00 | Q02
Yes | 2010-02-02 00:00:00 | Q03
Yes | 2010-02-10 00:00:00 | Q04
Yes | 2010-02-10 00:00:00 | Q05
Yes | 2010-08-28 00:00:00 | Q06
No
No
No
No
No
No
No
No
No
Yes | 2010-05-21 00:00:00 | 71
yes | 2010-09-02 00:00:00 | 75
Yes | 2010-09-02 00:00:00 | 76
Yes | 2010-10-21 00:00:00 | 77
YES | 2010-10-28 00:00:00 | 78
YES | 2010-09-07 00:00:00 | 80
YES | 2010-09-08 00:00:00 | 79
YES | 2010-07-29 00:00:00 | 81
Yes | 2010-11-03 00:00:00 | 82
Yes | 2010-11-04 00:00:00 | 83
YES | 2010-11-03 00:00:00 | 84
YES | 2010-11-03 00:00:00 | 85
YES | 2010-11-03 00:00:00 | 86
YES | 2010-11-03 00:00:00 | 87
Yes | 2010-11-08 00:00:00 | 88
YES | 2010-11-18 00:00:00 | 89
YES | 2010-11-18 00:00:00 | 90
Yes | 2010-11-19 00:00:00 | 91
Yes | 2010-11-19 00:00:00 | 92
YES | 2010-11-22 00:00:00 | 93
YES | 2010-11-23 00:00:00 | 94
YES | 2010-11-23 00:00:00 | 95
YES | 2010-11-23 00:00:00 | 97
Yes | 2010-12-02 00:00:00 | 98
Yes | 2010-11-16 00:00:00 | 96
Yes | 2010-12-09 00:00:00 | 99
Yes | 2010-12-09 00:00:00 | 101
Yes | 2010-12-09 00:00:00 | 102
YES | 2010-12-09 00:00:00 | 100
Yes | 2010-12-14 00:00:00 | 103
Yes | 2010-12-16 00:00:00 | 104
Yes | 2010-12-17 00:00:00 | 105
YES | 2011-01-04 00:00:00 | 106
Yes | 2011-01-04 00:00:00 | 107
Yes | 2011-01-06 00:00:00 | 108
Yes | 2011-01-19 00:00:00 | 109
Yes | 2011-01-19 00:00:00 | 110
Yes | 2011-01-24 00:00:00 | 111
YES | 2011-01-18 00:00:00 | 112
Yes | 2011-01-18 00:00:00 | 113
Yes | 2011-01-18 00:00:00 | 114
Yes | 2011-01-28 00:00:00 | 115
Yes | 2011-02-08 00:00:00 | 116
Yes | 2011-02-07 00:00:00 | 117
YES | 2010-09-22 00:00:00 | 118
YES | 2010-09-30 00:00:00 | 119
YES | 2010-09-09 00:00:00 | 120
YES | 2010-05-05 00:00:00 | 121
Yes | 2011-03-16 00:00:00 | 122
Yes | 2011-02-22 00:00:00 | 123
YES | 2011-02-22 00:00:00 | 124
YES | 2011-02-23 00:00:00 | 125
Yes | 2011-03-11 00:00:00 | 126
NO
NO
NO
No
NO
NO
NO
No
NO
NO
No
No
No
NO
No
NO