Spreadsheet: 61916d1262815074-conditional-formatting-based-on-5-named-ranges-conformating-test
Sheet: New HI DB 

 |  |  |  |  | Store# |  | Audit Date
 |  |  |  |  | 36 |  | 2009-11-23 00:00:00
 |  |  |  |  | 46 |  | 2009-02-27 00:00:00
 |  |  |  |  | 47 |  | 2009-08-14 00:00:00
 |  |  |  |  | 52 |  | 2009-09-10 00:00:00
 |  |  |  |  | 60 |  | 2009-10-23 00:00:00
 |  |  |  |  | 64 |  | 2009-08-06 00:00:00
 |  |  |  |  | 67 |  | 2009-11-18 00:00:00
 |  |  |  |  | 83 |  | 2009-10-16 00:00:00
 |  |  |  |  | 83 |  | 2009-10-29 00:00:00
 |  |  |  |  | 108 |  | 2010-12-14 00:00:00
 |  |  |  |  | 111 |  | 2009-10-19 00:00:00
 |  |  |  |  | 116 |  | 2009-09-21 00:00:00
 |  |  |  |  | 118 |  | 2009-10-05 00:00:00
 |  |  |  |  | 120 |  | 2010-12-18 00:00:00
 |  |  |  |  | 123 |  | 2009-10-13 00:00:00
 |  |  |  |  | 124 |  | 2009-03-09 00:00:00
 |  |  |  |  | 124 |  | 2010-06-23 00:00:00
 |  |  |  |  | 124 |  | 2010-09-21 00:00:00
 |  |  |  |  | 126 |  | 2009-09-09 00:00:00
 |  |  |  |  | 137 |  | 2009-10-06 00:00:00
 |  |  |  |  | 140 |  | 2009-11-23 00:00:00
 |  |  |  |  | 146 |  | 2009-09-11 00:00:00
 |  |  |  |  | 147 |  | 2009-08-19 00:00:00
 |  |  |  |  | 147 |  | 2010-12-02 00:00:00
 |  |  |  |  | 149 |  | 2009-11-12 00:00:00
 |  |  |  |  | 154 |  | 2009-10-12 00:00:00
 |  |  |  |  | 157 |  | 2009-10-19 00:00:00
 |  |  |  |  | 167 |  | 2009-09-02 00:00:00
 |  |  |  |  | 168 |  | 2009-10-27 00:00:00
 |  |  |  |  | 172 |  | 2010-11-25 00:00:00
 |  |  |  |  | 175 |  | 2009-10-23 00:00:00
 |  |  |  |  | 182 |  | 2009-09-16 00:00:00
 |  |  |  |  | 194 |  | 2009-07-30 00:00:00
 |  |  |  |  | 200 |  | 2009-09-25 00:00:00
 |  |  |  |  | 202 |  | 2009-10-23 00:00:00
 |  |  |  |  | 217 |  | 2009-11-09 00:00:00
 |  |  |  |  | 225 |  | 2010-06-17 00:00:00
 |  |  |  |  | 236 |  | 2009-11-17 00:00:00
 |  |  |  |  | 246 |  | 2010-12-18 00:00:00
 |  |  |  |  | 261 |  | 2009-09-24 00:00:00
 |  |  |  |  | 272 |  | 2009-09-22 00:00:00
 |  |  |  |  | 279 |  | 2010-10-16 00:00:00
 |  |  |  |  | 279 |  | 2010-10-22 00:00:00
 |  |  |  |  | 300 |  | 2009-09-10 00:00:00
 |  |  |  |  | 300 |  | 2009-09-10 00:00:00
 |  |  |  |  | 300 |  | 2010-12-02 00:00:00
 |  |  |  |  | 306 |  | 2010-02-12 00:00:00
 |  |  |  |  | 306 |  | 2010-08-20 00:00:00
 |  |  |  |  | 306 |  | 2010-08-20 00:00:00
 |  |  |  |  | 308 |  | 2009-09-09 00:00:00
 |  |  |  |  | 309 |  | 2009-09-29 00:00:00
 |  |  |  |  | 311 |  | 2009-10-27 00:00:00
 |  |  |  |  | 319 |  | 2009-10-18 00:00:00
 |  |  |  |  | 330 |  | 2009-08-04 00:00:00
 |  |  |  |  | 330 |  | 2009-10-09 00:00:00
 |  |  |  |  | 336 |  | 2009-10-22 00:00:00
 |  |  |  |  | 341 |  | 2009-11-19 00:00:00
 |  |  |  |  | 345 |  | 2009-10-26 00:00:00
 |  |  |  |  | 351 |  | 2009-08-11 00:00:00
 |  |  |  |  | 353 |  | 2009-11-05 00:00:00
 |  |  |  |  | 354 |  | 2009-08-26 00:00:00
 |  |  |  |  | 356 |  | 2009-11-24 00:00:00
 |  |  |  |  | 367 |  | 2009-08-10 00:00:00
 |  |  |  |  | 370 |  | 2010-12-11 00:00:00
 |  |  |  |  | 378 |  | 2009-12-16 00:00:00
 |  |  |  |  | 383 |  | 2009-11-04 00:00:00
 |  |  |  |  | 386 |  | 2009-09-16 00:00:00
 |  |  |  |  | 389 |  | 2009-08-24 00:00:00
 |  |  |  |  | 393 |  | 2009-10-14 00:00:00
 |  |  |  |  | 398 |  | 2009-11-19 00:00:00
 |  |  |  |  | 408 |  | 2009-10-06 00:00:00
 |  |  |  |  | 409 |  | 2009-09-23 00:00:00
 |  |  |  |  | 409 |  | 2010-03-16 00:00:00
 |  |  |  |  | 409 |  | 2010-02-07 00:00:00
 |  |  |  |  | 409 |  | 2010-09-23 00:00:00
 |  |  |  |  | 410 |  | 2009-08-25 00:00:00
 |  |  |  |  | 410 |  | 2009-09-17 00:00:00
 |  |  |  |  | 410 |  | 2009-08-25 00:00:00
 |  |  |  |  | 415 |  | 2009-10-21 00:00:00
 |  |  |  |  | 416 |  | 2010-11-30 00:00:00
 |  |  |  |  | 416 |  | 2010-05-12 00:00:00
 |  |  |  |  | 422 |  | 2009-11-23 00:00:00
 |  |  |  |  | 423 |  | 2009-10-06 00:00:00
 |  |  |  |  | 426 |  | 2009-09-21 00:00:00
 |  |  |  |  | 427 |  | 2009-08-11 00:00:00
 |  |  |  |  | 432 |  | 2009-10-22 00:00:00
 |  |  |  |  | 435 |  | 2009-09-28 00:00:00
 |  |  |  |  | 438 |  | 2009-10-27 00:00:00
 |  |  |  |  | 445 |  | 2009-08-26 00:00:00
 |  |  |  |  | 447 |  | 2009-09-12 00:00:00
 |  |  |  |  | 449 |  | 2010-12-01 00:00:00
 |  |  |  |  | 451 |  | 2009-09-14 00:00:00
 |  |  |  |  | 454 |  | 2009-08-26 00:00:00
 |  |  |  |  | 454 |  | 2010-04-06 00:00:00
 |  |  |  |  | 454 |  | 2009-01-09 00:00:00
 |  |  |  |  | 455 |  | 2009-10-15 00:00:00
 |  |  |  |  | 461 |  | 2009-08-13 00:00:00
 |  |  |  |  | 461 |  | 2009-08-13 00:00:00
 |  |  |  |  | 462 |  | 2010-09-03 00:00:00
 |  |  |  |  | 463 |  | 2009-08-03 00:00:00
 |  |  |  |  | 474 |  | 2009-04-04 00:00:00
 |  |  |  |  | 490 |  | 2010-10-28 00:00:00
 |  |  |  |  | 496 |  | 2009-09-08 00:00:00
 |  |  |  |  | 497 |  | 2008-12-29 00:00:00
 |  |  |  |  | 497 |  | 2010-08-03 00:00:00
 |  |  |  |  | 500 |  | 2010-12-03 00:00:00
 |  |  |  |  | 504 |  | 2009-08-26 00:00:00
 |  |  |  |  | 506 |  | 2009-11-05 00:00:00
 |  |  |  |  | 509 |  | 2010-07-23 00:00:00
 |  |  |  |  | 510 |  | 2009-10-23 00:00:00
 |  |  |  |  | 511 |  | 2009-03-12 00:00:00
 |  |  |  |  | 514 |  | 2010-01-28 00:00:00
 |  |  |  |  | 519 |  | 2010-05-27 00:00:00
 |  |  |  |  | 531 |  | 2009-10-14 00:00:00
 |  |  |  |  | 536 |  | 2010-12-16 00:00:00
 |  |  |  |  | 602 |  | 2010-12-17 00:00:00
 |  |  |  |  | 716 |  | 2009-09-22 00:00:00
 |  |  |  |  | 716 |  | 2010-09-22 00:00:00
 |  |  |  |  | 730 |  | 2009-10-29 00:00:00
 |  |  |  |  | 730 |  | 2010-10-29 00:00:00
 |  |  |  |  | 781 |  | 2009-09-09 00:00:00
 |  |  |  |  | 787 |  | 2009-11-09 00:00:00
 |  |  |  |  | 788 |  | 2009-09-24 00:00:00
 |  |  |  |  | 801 |  | 2010-04-24 00:00:00
 |  |  |  |  | 804 |  | 2010-07-07 00:00:00
 |  |  |  |  | 806 |  | 2010-10-16 00:00:00
 |  |  |  |  | 813 |  | 2009-08-12 00:00:00
 |  |  |  |  | 822 |  | 2009-09-10 00:00:00
 |  |  |  |  | 1091 |  | 2009-10-19 00:00:00
 |  |  |  |  | 1093 |  | 2010-11-18 00:00:00
 |  |  |  |  | 1102 |  | 2009-08-11 00:00:00
 |  |  |  |  | 1102 |  | 2009-08-12 00:00:00
 |  |  |  |  | 1103 |  | 2009-11-05 00:00:00
 |  |  |  |  | 1144 |  | 2010-11-30 00:00:00
 |  |  |  |  | 1155 |  | 2009-11-09 00:00:00
 |  |  |  |  | 1280 |  | 2009-10-22 00:00:00
 |  |  |  |  | 1301 |  | 2009-11-12 00:00:00
 |  |  |  |  | 1307 |  | 2009-07-29 00:00:00
 |  |  |  |  | 1406 |  | 2009-08-31 00:00:00
 |  |  |  |  | 1406 |  | 2009-11-17 00:00:00
 |  |  |  |  | 1425 |  | 2009-11-18 00:00:00
 |  |  |  |  | 1485 |  | 2009-12-01 00:00:00
 |  |  |  |  | 1503 |  | 2009-09-14 00:00:00
 |  |  |  |  | 1508 |  | 2009-07-30 00:00:00
 |  |  |  |  | 1512 |  | 2010-11-24 00:00:00
 |  |  |  |  | 1534 |  | 2009-09-18 00:00:00
 |  |  |  |  | 1539 |  | 2009-09-18 00:00:00
 |  |  |  |  | 1546 |  | 2009-11-06 00:00:00
 |  |  |  |  | 1581 |  | 2009-09-22 00:00:00
 |  |  |  |  | 1582 |  | 2009-10-26 00:00:00
 |  |  |  |  | 1582 |  | 2009-08-26 00:00:00
 |  |  |  |  | 1583 |  | 2009-09-14 00:00:00
 |  |  |  |  | 1617 |  | 2009-07-30 00:00:00
 |  |  |  |  | 1618 |  | 2009-09-14 00:00:00
 |  |  |  |  | 1679 |  | 2009-10-29 00:00:00
 |  |  |  |  | 1738 |  | 2009-10-27 00:00:00
 |  |  |  |  | 1738 |  | 2009-08-13 00:00:00
 |  |  |  |  | 1742 |  | 2009-09-25 00:00:00
 |  |  |  |  | 1743 |  | 2009-09-21 00:00:00
 |  |  |  |  | 1759 |  | 2009-07-29 00:00:00
 |  |  |  |  | 1759 |  | 2009-11-24 00:00:00
 |  |  |  |  | 1776 |  | 2009-08-31 00:00:00
 |  |  |  |  | 1776 |  | 2010-12-16 00:00:00
 |  |  |  |  | 1796 |  | 2009-11-14 00:00:00
 |  |  |  |  | 1825 |  | 2009-08-04 00:00:00
 |  |  |  |  | 1850 |  | 2010-11-30 00:00:00
 |  |  |  |  | 1852 |  | 2009-10-06 00:00:00
 |  |  |  |  | 1857 |  | 2009-07-30 00:00:00
 |  |  |  |  | 1904 |  | 2009-09-15 00:00:00
 |  |  |  |  | 1911 |  | 2009-11-04 00:00:00
 |  |  |  |  | 1921 |  | 2009-07-30 00:00:00
 |  |  |  |  | 1921 |  | 2009-09-01 00:00:00
 |  |  |  |  | 1922 |  | 2010-11-24 00:00:00
 |  |  |  |  | 1938 |  | 2010-12-11 00:00:00
 |  |  |  |  | 1949 |  | 2009-07-30 00:00:00
 |  |  |  |  | 1950 |  | 2009-11-12 00:00:00
 |  |  |  |  | 1951 |  | 2009-10-12 00:00:00
 |  |  |  |  | 1961 |  | 2009-09-22 00:00:00
 |  |  |  |  | 2036 |  | 2009-10-28 00:00:00
 |  |  |  |  | 2085 |  | 2009-10-22 00:00:00
 |  |  |  |  | 2112 |  | 2009-10-30 00:00:00
 |  |  |  |  | 2176 |  | 2009-11-23 00:00:00
 |  |  |  |  | 2180 |  | 2009-07-29 00:00:00
 |  |  |  |  | 2180 |  | 2009-07-29 00:00:00
 |  |  |  |  | 2180 |  | 2009-07-29 00:00:00
 |  |  |  |  | 2201 |  | 2009-11-02 00:00:00
 |  |  |  |  | 2271 |  | 2009-11-18 00:00:00