check numbers in a list
 

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

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

-----Original Message-----
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
.

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

"Jason Morin" wrote:

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

-----Original Message-----
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
.

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