hi jason, would it be possible to refine the formula to choose only the exact
new part number against the list.the formual that you gave me shows each
individual number in all the part numbers.ie if i put # 7 as a new part #
every #7 shows is highlited. it would make it easier to locate.ttx wynb

"WYN" wrote:

good day excelers,i have 7 columns d:j and 557 rows of seven digit part
numbers.what i have to do is check new part numbers against the existing
list,(unfortunately they are not in numerical order) and to highlite them if
possible.i can put the new part number in columns k2:q2.is there a method to
do this.any info will be greatly appreciated. thx wynb
--
wynb