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