check numbers in a list

[Guest]

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

 

[Jason Morin]

1. Select D1:J557.
2. Go to Format > Conditional Formatting.
3. Select "Formula Is" under Condition 1 and put:
=COUNTIF($K$2:$Q$2,D1)
4. Press the Format radio button and format as desired.

HTH
Jason
Atlanta, GA

 

[Guest]

hi jason,that worked like a charm.thank you. wynb

1. Select D1:J557.
2. Go to Format > Conditional Formatting.
3. Select "Formula Is" under Condition 1 and put:
=COUNTIF($K$2:$Q$2,D1)
4. Press the Format radio button and format as desired.

HTH
Jason
Atlanta, GA

 

[Guest]

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