Spreadsheet: 61916d1262815074-conditional-formatting-based-on-5-named-ranges-conformating-test
Sheet: Pre august date list

30
36 | 2009-11-23 00:00:00
38
46 | 2009-02-27 00:00:00
47
49
52
56 | 2009-03-18 00:00:00
60
61 | 2009-02-26 00:00:00
63 | 2009-03-17 00:00:00
64
67 | 2009-01-22 00:00:00
73
75
77
78 | 2009-05-05 00:00:00
80 |  | 2009-06-09 00:00:00
81 | 2009-03-20 00:00:00
82
83 | 2009-01-15 00:00:00
85
86
87
89
91 | 2009-03-17 00:00:00
92
94 | 2009-02-12 00:00:00
96 | 2009-03-03 00:00:00
98
100
102
106
108
109 | 2009-02-23 00:00:00
111
112
113
114 | 2009-02-25 00:00:00
116
118
119 | 2009-02-23 00:00:00
120
122 | 2009-05-07 00:00:00
123
124 | 2009-06-23 00:00:00
126
128
129
130
132
133
134 | 2009-04-28 00:00:00
136
137
140
142 | 2009-02-09 00:00:00
144
145
146
147 | 2009-04-09 00:00:00
149
150
153 | 2009-07-02 00:00:00
154 | 2009-04-13 00:00:00
157 | 2009-04-14 00:00:00
159
162 | 2009-07-27 00:00:00
165
167 | 2009-04-10 00:00:00
168
169 | 2009-07-20 00:00:00
170
171
172
174
175 | 2009-01-13 00:00:00
176 | 2009-01-14 00:00:00
177
178
179
182 | 2009-01-09 00:00:00
184
185
188 | 2009-02-26 00:00:00
190
191
193 | 2009-02-21 00:00:00
194 | 2009-07-13 00:00:00
196 | 2009-05-26 00:00:00
198 | 2009-04-03 00:00:00
200 | 2009-06-24 00:00:00
201 | 2009-02-09 00:00:00
202
203
204
205 | 2009-03-18 00:00:00 | 2009-06-30 00:00:00
206
207
208
209 | 2009-04-29 00:00:00 | 2009-04-20 00:00:00
211 | 2009-06-17 00:00:00
212 | 2009-05-12 00:00:00 | 2009-05-12 00:00:00
214
215 |  | 2009-05-21 00:00:00
217
218
219 | 2009-05-13 00:00:00
220 | 2009-03-03 00:00:00
223 | 2009-02-03 00:00:00
225
226
231
232
236 | 2009-01-12 00:00:00
238
242
243
245
246
247 | 2009-07-22 00:00:00
249
251
252
253
254 | 2009-01-20 00:00:00
255 | 2009-01-12 00:00:00
257
258 |  | 2009-06-26 00:00:00
259
260
261 | 2009-02-04 00:00:00 | 2009-07-08 00:00:00
262
263
264
265
266
268
270
272
274
275
276
277
278
279 | 2009-06-02 00:00:00
283
286
288
292
293
294 | 2009-01-29 00:00:00
295
296
300 | 2009-05-28 00:00:00
301
302 | 2009-04-17 00:00:00
304 | 2009-02-09 00:00:00
305
306
307
308
309 | 2009-03-03 00:00:00
310
311
312
314
316
317
318
319
322
323 | 2009-01-15 00:00:00
324
326
328
330 | 2009-04-15 00:00:00
332
334
336
339
341 | 2009-04-07 00:00:00
342
343
345
346 | 2009-04-06 00:00:00
350
351 | 2009-01-30 00:00:00
352 |  | 2009-07-02 00:00:00
353 | 2009-05-14 00:00:00
354
356
357
359
360
362 | 2009-01-22 00:00:00 | 2009-05-28 00:00:00
364 | 2009-04-13 00:00:00
367 | 2009-03-27 00:00:00
368
370 |  | 2009-05-06 00:00:00
371
372
373
374
375
376
378 | 2009-06-03 00:00:00
380
383 | 2009-04-23 00:00:00
384
385
386
389 | 2009-01-13 00:00:00
391
393 | 2009-02-23 00:00:00
394
395
398 | 2009-05-22 00:00:00
399 | 2009-01-21 00:00:00
401
402
404
408
409 | 2009-03-16 00:00:00
410 | 2009-01-14 00:00:00
411
413 | 2009-02-23 00:00:00
414
415
416
417 | 2009-04-29 00:00:00
420
422 | 2009-02-11 00:00:00
423 | 2009-01-26 00:00:00
424 | 2009-02-04 00:00:00
426 | 2009-05-01 00:00:00
427 | 2009-03-23 00:00:00
429
430
431 |  | 2009-07-09 00:00:00
432 | 2009-03-24 00:00:00
433 | 2009-03-23 00:00:00
434 | 2009-05-29 00:00:00
435 | 2009-06-05 00:00:00
437
438 | 2009-03-06 00:00:00
439 |  | 2009-06-23 00:00:00
440
441
443 | 2009-05-11 00:00:00
445
446
447 | 2009-01-13 00:00:00 | 2009-06-12 00:00:00
449 | 2009-05-19 00:00:00
450
451
452
453 | 2009-01-30 00:00:00
454 | 2009-04-06 00:00:00
455
456
457
458
460
461 | 2009-01-07 00:00:00
462
463
467
471
472
474
476
477 | 2009-04-29 00:00:00
478
479 | 2009-04-30 00:00:00
480
481 | 2009-03-05 00:00:00
482
483
485
486
489 | 2009-04-15 00:00:00
490
491
492 | 2009-06-23 00:00:00
493
494
495
496
497
500
502
504
506
509
510
511 | 2009-03-12 00:00:00
514
516 | 2009-04-27 00:00:00 | 2009-04-30 00:00:00
517 | 2009-01-07 00:00:00
518
519
521 | 2009-05-04 00:00:00
528
531 | 2009-01-20 00:00:00
536
539
701 | 2009-02-04 00:00:00
707
709
711
716
724 | 2009-04-14 00:00:00
730 |  | 2009-07-02 00:00:00
731
732
780
781 | 2009-01-22 00:00:00
782
785
787 | 2009-03-30 00:00:00
788
789 | 2009-03-10 00:00:00
790 | 2009-04-06 00:00:00
791
792 | 2009-03-23 00:00:00
795
796
801
802
803
804
806
807 | 2009-04-24 00:00:00
810
812 | 2009-01-16 00:00:00
813
816
817 | 2009-02-26 00:00:00
822 | 2009-01-09 00:00:00
824
1058
1061
1062
1088
1091
1092
1093
1100
1101 | 2009-06-18 00:00:00
1102 | 2009-02-09 00:00:00
1103
1104
1106
1107 | 2009-02-24 00:00:00
1108
1110
1115 | 2009-05-06 00:00:00
1116
1117 |  | 2009-02-27 00:00:00
1118
1133
1135
1140
1141
1142
1143
1144
1145
1151
1152
1168 |  | 2009-04-15 00:00:00
1178
1190 | 2009-02-25 00:00:00
1191
1192
1193
1194
1195 |  | 2009-06-26 00:00:00
1204
1266
1280
1281
1284
1288
1289 | 2009-03-30 00:00:00
1293 |  | 2009-05-19 00:00:00
1301
1307
1366 |  | 2009-05-29 00:00:00
1367
1399
1402
1406
1407
1408
1411
1412
1413
1414
1424
1425
1469
1480
1481
1483
1484 | 2009-02-18 00:00:00
1485
1487 | 2009-05-15 00:00:00
1488
1490
1491
1492
1493
1494
1495 | 2009-04-27 00:00:00
1500
1501 | 2009-07-17 00:00:00
1502 | 2009-01-26 00:00:00
1503
1504
1505
1506
1507
1508
1509
1510
1511
1512
1515
1516
1517
1518 | 2009-02-17 00:00:00
1519 | 2009-02-11 00:00:00
1520
1521 | 2009-02-12 00:00:00
1530
1532
1533
1534 | 2009-04-20 00:00:00
1535
1536
1538 | 2009-04-24 00:00:00
1540
1541
1542
1543 | 2009-01-26 00:00:00
1544
1545 | 2009-03-24 00:00:00
1546 | 2009-01-12 00:00:00
1547
1548
1549
1553
1554 | 2009-01-28 00:00:00
1557
1560
1563
1564
1565
1567
1568
1569
1570
1571
1573
1574
1575
1576
1577
1578
1579
1581 | 2009-06-27 00:00:00
1582 | 2009-03-24 00:00:00
1583 | 2009-01-07 00:00:00
1584
1585
1586
1588 | 2009-02-12 00:00:00
1590
1591 | 2009-04-22 00:00:00
1592
1593
1594
1598
1602
1603
1614
1617 | 2009-01-15 00:00:00
1618 | 2009-03-12 00:00:00
1679
1680
1681
1682
1683 | 2009-04-30 00:00:00
1684
1688
1689
1690
1691
1693
1716 | 2009-03-05 00:00:00
1720
1721
1722 |  | 2009-07-06 00:00:00
1723
1724 | 2009-07-20 00:00:00
1725 |  | 2009-07-30 00:00:00
1726
1727
1728
1729
1730
1738 | 2009-03-05 00:00:00
1739
1740
1741
1742 | 2009-03-11 00:00:00
1743 | 2009-02-20 00:00:00
1749 | 2009-01-28 00:00:00
1754
1755
1756
1757 | 2009-02-18 00:00:00
1758
1759
1763 | 2009-06-03 00:00:00
1766 | 2009-02-26 00:00:00
1770
1775
1776
1777
1778
1779
1780
1781
1782
1783
1784
1787 | 2009-05-08 00:00:00
1792 | 2009-02-26 00:00:00
1793
1796
1809
1810
1811
1812 |  | 2009-06-19 00:00:00
1813
1814
1815
1816
1817 | 2009-03-27 00:00:00
1818
1819
1825
1826
1828
1830
1831
1832
1833
1835
1836
1848 | 2009-06-17 00:00:00
1849
1850 | 2009-02-09 00:00:00
1851 | 2009-07-23 00:00:00
1852
1853
1855
1856
1857
1858
1862
1863
1873
1874
1875
1885
1887
1888
1889 | 2009-04-13 00:00:00
1890
1891
1893
1896
1897
1898
1899
1900
1902
1903
1904 | 2009-04-02 00:00:00
1905
1906
1907
1908
1909
1910
1911
1912
1913 | 2009-04-09 00:00:00 | 2009-05-12 00:00:00
1914
1915
1917 | 2009-04-03 00:00:00
1918
1919
1920
1921 | 2009-05-18 00:00:00
1922
1923
1924
1925
1930
1933
1935 | 2009-03-03 00:00:00
1936 | 2009-02-23 00:00:00
1938
1940 | 2009-04-22 00:00:00
1941
1942 |  | 2009-03-13 00:00:00
1943
1945
1946 | 2009-04-30 00:00:00
1947
1948 | 2009-01-29 00:00:00
1949
1950
1951
1952
1953
1955
1956 | 2009-02-19 00:00:00
1957 | 2009-04-28 00:00:00
1958 | 2009-01-23 00:00:00
1959
1961
1962
2035
2036
2037 | 2009-05-18 00:00:00
2038
2047
2050
2054
2055
2079
2082 | 2009-03-26 00:00:00
2085
2086
2088
2094
2105
2108
2133
2167 | 2009-04-07 00:00:00
2176 | 2009-03-31 00:00:00
2199
2201
2207 | 2009-06-22 00:00:00
2208
2227 |  |  | 2009-07-22 00:00:00 | 2009-01-28 00:00:00 | 2009-07-21 00:00:00 | 2009-07-22 00:00:00
2250
2270 | 2009-05-21 00:00:00
2271
2272