Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
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 . |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alphabetical list of Numbers are not correct! | Excel Discussion (Misc queries) | |||
removing firsts two numbers from a list of #s | Excel Worksheet Functions | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
list of sequential numbers | Excel Discussion (Misc queries) | |||
Random list (1-45) without repeating numbers? | Excel Worksheet Functions |