Spreadsheet: 161101d1339417223-conditional-formatting-and-data-valiation-2007-tester-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YYYYMMDD |  | YYYYMMDD |  | YYYYMMDD
String (12) | Number |  |  | String (12) | Number | String (12) | Number | String (25) | String (3) | String (12) | String (3) | String (3) | String (2) | String (2) | Date | Number | Date | Number | Date | Number | String (3)
TMVMCU | TMLDNM | [NAME] | Primary Key Validation | TMNMCU | TMORGN | TMMCUX | TMANCC | TMCTY1 | [NAME] | TMADDZ | TMCTR | TMZON | TMLDTY | TMLDLS | TMLOAD_D | TMTMLS | TMPPDJ_D | TMPMDT | TMADDJ_D | TMADTM | TMMOT
GB10270 | 4615 |  |  | GB10270 | 535996 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 51400 | 20120522 | 51400 |  |  | C2
GB10270 | 4640 |  |  | GB10270 | 535996 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 65030 | 20120522 | 65030 |  |  | C2
GB15180 | 4887 |  |  | GB15180 | 535943 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 30000 | 20120522 | 30000 | 20120522 | 30000 | C2
GB10200 | 4622 |  |  | GB10200 | 535977 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 81652 | 20120522 | 81652 |  |  | C2
GB10200 | 4601 |  |  | GB10200 | 535977 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 53219 | 20120522 | 53219 | 20120522 | 53000 | C2
GB10200 | 4598 |  |  | GB10200 | 535977 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 65701 | 20120522 | 65701 | 20120522 | 70000 | C2
GB10800 | 4557 |  |  | GB10800 | 535988 |  |  |  |  |  |  |  | CS | 80 | 20120521 | 220440 | 20120521 | 220440 |  |  | C1
GB10800 | 4771 |  |  | GB10800 | 535988 |  |  |  |  |  |  |  | ST | 80 | 20120523 | 53057 | 20120523 | 53057 |  |  | C1
GB10300 | 4554 |  |  | GB10300 | 535979 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 51026 | 20120522 | 51026 |  |  | C2
GB10300 | 4582 |  |  | GB10300 | 535979 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 53911 | 20120522 | 53911 |  |  | C2
GB10270 | 4617 |  |  | GB10270 | 535996 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 72049 | 20120522 | 72049 |  |  | C2
GB10200 | 4936 |  |  | GB10200 | 535977 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 74500 | 20120522 | 74500 | 20120522 | 74500 | C2
GB10700 | 6300 |  |  | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 210559 | 20120523 | 210559 | 20120523 | 210559 | C1
GB10700 | 6307 |  |  | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 0 | 20120523 | 0 | 20120523 | 210016 | C1
GB10700 | 6596 |  |  | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120524 | 70000 | 20120524 | 70000 | 20120524 | 70000 | C2
GB10700 | 5875 |  |  | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 120500 | 20120523 | 120500 |  |  | C2
GB10700 | 6272 |  |  | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 200500 | 20120523 | 200500 | 20120523 | 200500 | C2
GB10700 | 6274 |  |  | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 192500 | 20120523 | 192500 | 20120523 | 192500 | C2
GB10200 | 5785 |  |  | GB10200 | 535977 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 44511 | 20120523 | 44511 | 20120523 | 44511 | C2
GB10700 | 6285 |  |  | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 0 | 20120523 | 0 | 20120523 | 0 | C2
GB10700 | 6286 |  |  | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 195559 | 20120523 | 195559 | 20120523 | 195559 | C1
GB10700 | 6287 |  |  | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 0 | 20120523 | 0 | 20120523 | 0 | C2
GB10700 | 6167 |  |  | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 170359 | 20120523 | 170359 |  |  | C1
GB10700 | 6289 |  |  | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120524 | 0 | 20120524 | 0 | 20120524 | 0 | C2
GB10700 | 6256 |  |  | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 184359 | 20120523 | 184359 | 20120523 | 184359 | C1
GB15180 | 4868 |  |  | GB15180 | 535943 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 135500 | 20120522 | 135500 |  |  | C2
GB10200 | 5061 |  |  | GB10200 | 535977 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 53043 | 20120522 | 53043 | 20120522 | 53043 | C2
GB10200 | 4808 |  |  | GB10200 | 535977 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 43000 | 20120522 | 43000 | 20120522 | 43000 | C2
GB10650 | 4544 |  |  | GB10650 | 536003 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 73057 | 20120522 | 73057 |  |  | C1
GB10650 | 4877 |  |  | GB10650 | 536003 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 140500 | 20120522 | 140500 |  |  | C2
GB10200 | 4593 |  |  | GB10200 | 535977 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 44500 | 20120522 | 44500 |  |  | C2
GB10200 | 4600 |  |  | GB10200 | 535977 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 44500 | 20120522 | 44500 |  |  | C2
GB10400 | 5150 |  |  | GB10400 | 535980 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 44500 | 20120523 | 44500 |  |  | C2
GB10800 | 4552 |  |  | GB10800 | 535988 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 13855 | 20120522 | 13855 |  |  | C1
GB10200 | 5795 |  |  | GB10200 | 535977 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 44511 | 20120523 | 44511 | 20120523 | 44511 | C2
GB10700 | 4567 |  |  | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 70707 | 20120522 | 70707 | 20120522 | 70707 | C1
GB10300 | 4581 |  |  | GB10300 | 535979 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 52458 | 20120522 | 52458 |  |  | C2
GB10200 | 4596 |  |  | GB10200 | 535977 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 44500 | 20120522 | 44500 |  |  | C2
GB10200 | 5844 |  |  | GB10200 | 535977 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 43000 | 20120523 | 43000 | 20120523 | 43000 | C2
GB10700 | 6660 |  |  | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120524 | 123000 | 20120524 | 123000 | 20120524 | 123000 | C2
GB10600 | 6363 |  |  | GB10600 | 535982 |  |  |  |  |  |  |  | CS | 80 | 20120524 | 112706 | 20120524 | 112706 | 20120524 | 101359 | C1
GB10250 | 6662 |  |  | GB10250 | 535978 |  |  |  |  |  |  |  | CS | 80 | 20120524 | 44500 | 20120524 | 44500 | 20120524 | 44500 | C2
GB10700 | 6645 |  |  | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120524 | 124922 | 20120524 | 124922 |  |  | C1
GB10700 | 6703 |  |  | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120524 | 132359 | 20120524 | 132359 | 20120524 | 132359 | C1
GB10300 | 6237 |  |  | GB10300 | 535979 |  |  |  |  |  |  |  | CS | 80 | 20120524 | 40834 | 20120524 | 40834 |  |  | C2
GB10200 | 6012 |  |  | GB10200 | 535977 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 164900 | 20120523 | 164900 |  |  | C2
GB10200 | 6211 |  |  | GB10200 | 535977 |  |  |  |  |  |  |  | CS | 80 | 20120524 | 55230 | 20120524 | 55230 |  |  | C2
GB10200 | 6204 |  |  | GB10200 | 535977 |  |  |  |  |  |  |  | CS | 80 | 20120524 | 44500 | 20120524 | 44500 |  |  | C2
GB10700 | 6391 |  |  | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120524 | 91500 | 20120524 | 91500 |  |  | C2
GB10300 | 6229 |  |  | GB10300 | 535979 |  |  |  |  |  |  |  | CS | 80 | 20120524 | 63514 | 20120524 | 63514 |  |  | C2
GB10700 | 6306 |  |  | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120524 | 50810 | 20120524 | 50810 | 20120524 | 50810 | C2
GB10700 | 6043 |  |  | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 214737 | 20120523 | 214737 | 20120523 | 214737 | C1
GB10270 | 6197 |  |  | GB10270 | 535996 |  |  |  |  |  |  |  | CS | 80 | 20120524 | 65030 | 20120524 | 65030 |  |  | C2
GB10180 | 6351 |  |  | GB10180 | 535975 |  |  |  |  |  |  |  | CS | 80 | 20120524 | 82654 | 20120524 | 82654 |  |  | C2
GB10800 | 4788 |  |  | GB10800 | 535988 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 43558 | 20120523 | 43558 |  |  | C1
GB10800 | 4950 |  |  | GB10800 | 535988 |  |  |  |  |  |  |  | ST | 80 | 20120522 | 160109 | 20120522 | 160109 |  |  | C1
GB10250 | 6550 |  |  | GB10250 | 535978 |  |  |  |  |  |  |  | CS | 80 | 20120524 | 40000 | 20120524 | 40000 | 20120524 | 40000 | C2