Spreadsheet: 121960d1316528040-how-to-create-conditional-formatting-to-identify-like-numbers-file-for-help-with-2
Sheet: Data

Status | Order | Part Number | Operation | Oper Description | [NAME] | Complete | Due Date | Remaing Hrs | [NAME] | [NAME]
COMING | 490175-000 | 100 | 10 | test1 | 500 | 0 | 2011-08-10 00:00:00 | 1 | test | test2 | 40765_1
COMING | 490175-000 | 100 | 20 | test2 | 500 | 0 | 2011-08-10 00:00:00 | 4.24 | test | test3 | 40765_2
COMING | ST9044-000 | 122 | 10 | test3 | 500 | 0 | 2011-08-11 00:00:00 | 1 | test | test4 | 40766_1
COMING | ST9044-000 | 211 | 20 | test4 | 500 | 0 | 2011-08-11 00:00:00 | 1 | test | test5 | 40766_2
COMING | 494494-000 | 211 | 10 | test5 | 500 | 0 | 2011-09-09 00:00:00 | 0.5 | test | test6 | 40795_1
COMING | 494494-000 | 211 | 20 | test6 | 500 | 0 | 2011-09-09 00:00:00 | 0.03 | test | [NAME] | 40795_2
COMING | 494397-000 | 155 | 10 | [NAME] | 500 | 0 | 2011-09-15 00:00:00 | 0.5 | test | test8 | 40801_1
COMING | 494397-000 | 155 | 20 | test8 | 500 | 0 | 2011-09-15 00:00:00 | 10.01 | test | test9 | 40801_2
COMING | 494694-000 | 1 | 10 | test9 | 500 | 0 | 2011-09-20 00:00:00 | 1 | test | test10 | 40806_1
COMING | 494694-000 | 816531 | 20 | test10 | 500 | 0 | 2011-09-20 00:00:00 | 0.79 | test | test11 | 40806_2
COMING | 494695-000 | 68161 | 10 | test11 | 500 | 0 | 2011-09-20 00:00:00 | 0.5 | test | test12 | 40806_3
COMING | 494695-000 | 84981 | 20 | test12 | 500 | 0 | 2011-09-20 00:00:00 | 0.05 | test | test13 | 40806_4
COMING | 494699-000 | 65121 | 10 | test13 | 500 | 0 | 2011-09-20 00:00:00 | 0.5 | test | test14 | 40806_5
COMING | 494699-000 | 651131 | 20 | test14 | 500 | 0 | 2011-09-20 00:00:00 | 0.81 | test | test15 | 40806_6
WAITING | ST5032-000 | 555 | 10 | test15 | 500 | 0 |  | 0.5 | test | test16 | _0
WAITING | ST5032-000 | 555 | 20 | test16 | 500 | 0 |  | 5 | test | test17 | _0
WAITING | 494502-000 | 555 | 10 | test17 | 500 | 0 | 2011-09-01 00:00:00 | 0.5 | test | test18 | 40787_1
WAITING | 494502-000 | 555 | 20 | test18 | 500 | 0 | 2011-09-01 00:00:00 | 5 | test | test19 | 40787_2
WAITING | 494665-000 | 55 | 10 | test19 | 500 | 0 | 2011-09-05 00:00:00 | 0.5 | test | test20 | 40791_1
WAITING | 494413-000 | 55 | 10 | test20 | 500 | 0 | 2011-09-06 00:00:00 | 1 | test | test21 | 40792_1
WAITING | 494413-000 | 555 | 20 | test21 | 500 | 0 | 2011-09-06 00:00:00 | 0.67 | test | test22 | 40792_2
WAITING | 494673-000 | 999 | 10 | test22 | 500 | 0 | 2011-09-06 00:00:00 | 0.5 | test | test23 | 40792_3
WAITING | 494665-000 | 8888 | 20 | test23 | 500 | 0 | 2011-09-07 00:00:00 | 42.5 | test | test24 | 40793_1
WAITING | ST5030-000 | 9999 | 10 | test24 | 500 | 0 | 2011-09-07 00:00:00 | 0.5 | test | test25 | 40793_2
WAITING | ST5030-000 | 89898 | 20 | test25 | 500 | 0 | 2011-09-07 00:00:00 | 4.29 | test | test26 | 40793_3
WAITING | 493106-000 | 898988 | 10 | test26 | 500 | 0 | 2011-09-08 00:00:00 | 0.5 | test | test27 | 40794_1
WAITING | 493106-000 | 98988 | 20 | test27 | 500 | 0 | 2011-09-08 00:00:00 | 2 | test | test28 | 40794_2
WAITING | 494673-000 | 89898 | 20 | test28 | 500 | 0 | 2011-09-08 00:00:00 | 42.5 | test | test29 | 40794_3
WAITING | 495346-000 | 8777 | 10 | test29 | 500 | 0 | 2011-09-08 00:00:00 | 1.5 | test | test30 | 40794_4
WAITING | 495346-000 | 8777 | 20 | test30 | 500 | 0 | 2011-09-08 00:00:00 | 0.04 | test | test31 | 40794_5
WAITING | 494486-000 | 8777 | 10 | test31 | 500 | 0 | 2011-09-09 00:00:00 | 0.5 | test | test32 | 40795_3
WAITING | 494486-000 | 400 | 20 | test32 | 500 | 0 | 2011-09-09 00:00:00 | 4 | test | test33 | 40795_4
WAITING | 494489-000 | 455 | 10 | test33 | 500 | 0 | 2011-09-09 00:00:00 | 1.5 | test | test34 | 40795_5
WAITING | 494489-000 | 989 | 20 | test34 | 500 | 0 | 2011-09-09 00:00:00 | 0.67 | test | test35 | 40795_6
WAITING | 494414-000 | 788 | 10 | test35 | 500 | 0 | 2011-09-09 00:00:00 | 0.5 | test | test36 | 40795_7
WAITING | 494414-000 | 444 | 20 | test36 | 500 | 0 | 2011-09-09 00:00:00 | 0.5 | test | test37 | 40795_8
WAITING | 494492-000 | 4412 | 10 | test37 | 500 | 0 | 2011-09-12 00:00:00 | 2 | test | test38 | 40798_1
WAITING | 494492-000 | 8487 | 20 | test38 | 500 | 0 | 2011-09-12 00:00:00 | 0.42 | test | test39 | 40798_2
WAITING | 494420-000 | 4512 | 10 | test39 | 500 | 0 | 2011-09-12 00:00:00 | 0.5 | test | [NAME] | 40798_3
WAITING | 494420-000 | 448 | 20 | [NAME] | 500 | 0 | 2011-09-12 00:00:00 | 0.55 | test | test41 | 40798_4
WAITING | 494420-000 | 351351 | 30 | test41 | 500 | 0 | 2011-09-12 00:00:00 | 2 | test | test42 | 40798_5
WAITING | 494420-000 | 489498 | 40 | test42 | 500 | 0 | 2011-09-12 00:00:00 | 0.55 | test | test43 | 40798_6
WAITING | 494421-000 | 13548 | 10 | test43 | 500 | 0 | 2011-09-12 00:00:00 | 2 | test | test44 | 40798_7
WAITING | 494421-000 | 4654654 | 20 | test44 | 500 | 0 | 2011-09-12 00:00:00 | 3.19 | test | test45 | 40798_8
WAITING | 494424-000 | 849489 | 10 | test45 | 500 | 0 | 2011-09-12 00:00:00 | 1 | test | test46 | 40798_9
WAITING | 494424-000 | 635459 | 20 | test46 | 500 | 0 | 2011-09-12 00:00:00 | 7.15 | test | test47 | 40798_10
WAITING | 495415-000 | 984984 | 10 | test47 | 500 | 0 | 2011-09-13 00:00:00 | 1.5 | test | test48 | 40799_1
WAITING | 495415-000 | 354354 | 20 | test48 | 500 | 0 | 2011-09-13 00:00:00 | 6 | test | test49 | 40799_2
WAITING | 494500-000 | 98464 | 10 | test49 | 500 | 0 | 2011-09-13 00:00:00 | 0.5 | test | test50 | 40799_3
WAITING | 494500-000 | 464 | 20 | test50 | 500 | 0 | 2011-09-13 00:00:00 | 0.35 | test | test51 | 40799_4
WAITING | 494714-000 | 44 | 10 | test51 | 500 | 0 | 2011-09-14 00:00:00 | 0.5 | test | test52 | 40800_1
WAITING | 494714-000 | 64 | 20 | test52 | 500 | 0 | 2011-09-14 00:00:00 | 2.86 | test | [NAME] | 40800_2
WAITING | 494702-000 | 894898 | 10 | [NAME] | 500 | 0 | 2011-09-15 00:00:00 | 0.5 | test | test54 | 40801_3
WAITING | 494702-000 | 465498 | 20 | test54 | 500 | 0 | 2011-09-15 00:00:00 | 2.92 | test | test55 | 40801_4
WAITING | 494484-000 | 8777 | 10 | test55 | 500 | 0 | 2011-09-16 00:00:00 | 0.5 | test | test56 | 40802_1
WAITING | 494484-000 | 8777 | 20 | test56 | 500 | 0 | 2011-09-16 00:00:00 | 0.3 | test | test57 | 40802_2
WAITING | 494495-000 | 948494 | 10 | test57 | 500 | 0 | 2011-09-16 00:00:00 | 3 | test | test58 | 40802_3
WAITING | 494495-000 | 8777 | 20 | test58 | 500 | 0 | 2011-09-16 00:00:00 | 0.73 | test | test59 | 40802_4
WAITING | 494496-000 | 9849 | 10 | test59 | 500 | 0 | 2011-09-16 00:00:00 | 0.5 | test | test60 | 40802_5
WAITING | 494496-000 | 8984 | 20 | test60 | 500 | 0 | 2011-09-16 00:00:00 | 0.64 | test | test61 | 40802_6
WAITING | 494698-000 | 8777 | 10 | test61 | 500 | 0 | 2011-09-16 00:00:00 | 1 | test | test62 | 40802_7
WAITING | 494698-000 | 44847 | 20 | test62 | 500 | 0 | 2011-09-16 00:00:00 | 21.52 | test | test63 | 40802_8
WAITING | 490787-000 | 4448 | 10 | test63 | 500 | 0 | 2011-09-16 00:00:00 | 1 | test | test64 | 40802_9
WAITING | 490787-000 | 8777 | 20 | test64 | 500 | 0 | 2011-09-16 00:00:00 | 20 | test | test65 | 40802_10
WAITING | 494401-000 | 8777 | 10 | test65 | 500 | 0 | 2011-09-19 00:00:00 | 0.5 | test | test66 | 40805_1
WAITING | 494401-000 | 45454 | 20 | test66 | 500 | 0 | 2011-09-19 00:00:00 | 0.5 | test | test67 | 40805_2
WAITING | 494412-000 | 454545 | 10 | test67 | 500 | 0 | 2011-09-19 00:00:00 | 0.5 | test | test68 | 40805_3
WAITING | 494412-000 | 8484 | 20 | test68 | 500 | 0 | 2011-09-19 00:00:00 | 1 | test | test69 | 40805_4
WAITING | 494697-000 | 89494984 | 10 | test69 | 500 | 0 | 2011-09-20 00:00:00 | 2 | test | test70 | 40806_7
WAITING | 494697-000 | 89494 | 20 | test70 | 500 | 0 | 2011-09-20 00:00:00 | 0.86 | test | test71 | 40806_8
WAITING | 494701-000 | 894984 | 10 | test71 | 500 | 0 | 2011-09-21 00:00:00 | 2 | test | test72 | 40807_1
WAITING | 494701-000 | 9949 | 20 | test72 | 500 | 0 | 2011-09-21 00:00:00 | 2 | test | test73 | 40807_2
WAITING | 494419-000 | 8949849 | 30 | test73 | 500 | 0 | 2011-09-21 00:00:00 | 0.5 | test | test74 | 40807_3
WAITING | 494419-000 | 8498 | 40 | test74 | 500 | 0 | 2011-09-21 00:00:00 | 0.5 | test | test75 | 40807_4
WAITING | 495423-000 | 8777 | 10 | test75 | 500 | 0 | 2011-09-22 00:00:00 | 0.5 | test | test76 | 40808_1
WAITING | 495423-000 | 8777 | 20 | test76 | 500 | 0 | 2011-09-22 00:00:00 | 1.67 | test | test77 | 40808_2
WAITING | 488151-000 | 8777 | 10 | test77 | 500 | 0 | 2011-09-22 00:00:00 | 0.5 | test | test78 | 40808_3
WAITING | 488151-000 | 8 | 20 | test78 | 500 | 0 | 2011-09-22 00:00:00 | 7.77 | test | test79 | 40808_4
WAITING | 494485-000 | 8777 | 10 | test79 | 500 | 0 | 2011-09-23 00:00:00 | 0.5 | test | test80 | 40809_1
WAITING | 494485-000 | 8777 | 20 | test80 | 500 | 0 | 2011-09-23 00:00:00 | 12 | test | test81 | 40809_2
WAITING | 494712-000 | 88 | 10 | test81 | 500 | 0 | 2011-09-23 00:00:00 | 0.5 | test | test82 | 40809_3
WAITING | 494712-000 | 88 | 20 | test82 | 500 | 0 | 2011-09-23 00:00:00 | 13.32 | test | test83 | 40809_4
WAITING | 494696-000 | 88 | 10 | test83 | 500 | 0 | 2011-09-26 00:00:00 | 1 | test | test84 | 40812_1
WAITING | 494696-000 | 8 | 20 | test84 | 500 | 0 | 2011-09-26 00:00:00 | 3.33 | test | test85 | 40812_2
WAITING | 495343-000 | 8777 | 10 | test85 | 500 | 0 | 2011-09-27 00:00:00 | 0.5 | test | test86 | 40813_1
WAITING | 495343-000 | 8 | 20 | test86 | 500 | 0 | 2011-09-27 00:00:00 | 2 | test | test87 | 40813_2
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0