check numbers in a list

W

WYN

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
 
J

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
 
W

WYN

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

Jason Morin said:
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
Click to expand...
 
W

WYN

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
 
Top