Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding selected numbers within a master list
I have a list of about 300 UPC numbers that have been extracted from a master
list of about 2,000 UPC numbers. These lists are on 2 separate sheets, and the 300 UPC numbers are not in a consecutive series. I want to highlight the 300 UPC numbers within the master list. I don't have time to use the "find" function 300 times. Suggestions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding selected numbers within a master list
Assuming your two lists are in column A of their respective sheets,
highlight all the cells in the master list with A1 as the active cell, and click on Format | Conditional Formatting, then in the first box choose Formula Is rather than Cell Value Is. In the Formula box enter this: =NOT(ISNA(MATCH(A1,Sheet2!A$1:A$300,0))) (adjusting the sheet name to the one you use). Then click on the Format button, click on the Patterns tab (for background colour) and choose the colour you want. Click OK twice to exit the dialogue box. Hope this helps. Pete "JennaB" wrote in message ... I have a list of about 300 UPC numbers that have been extracted from a master list of about 2,000 UPC numbers. These lists are on 2 separate sheets, and the 300 UPC numbers are not in a consecutive series. I want to highlight the 300 UPC numbers within the master list. I don't have time to use the "find" function 300 times. Suggestions? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding selected numbers within a master list
=isnumber(match())
may be a little easier to understand. Pete_UK wrote: Assuming your two lists are in column A of their respective sheets, highlight all the cells in the master list with A1 as the active cell, and click on Format | Conditional Formatting, then in the first box choose Formula Is rather than Cell Value Is. In the Formula box enter this: =NOT(ISNA(MATCH(A1,Sheet2!A$1:A$300,0))) (adjusting the sheet name to the one you use). Then click on the Format button, click on the Patterns tab (for background colour) and choose the colour you want. Click OK twice to exit the dialogue box. Hope this helps. Pete "JennaB" wrote in message ... I have a list of about 300 UPC numbers that have been extracted from a master list of about 2,000 UPC numbers. These lists are on 2 separate sheets, and the 300 UPC numbers are not in a consecutive series. I want to highlight the 300 UPC numbers within the master list. I don't have time to use the "find" function 300 times. Suggestions? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding an average of a list that could have 0 to 10 numbers in it | Excel Discussion (Misc queries) | |||
finding the median from a list of unsorted numbers | Excel Discussion (Misc queries) | |||
Finding a predetermined Sum from a List of Numbers | Excel Discussion (Misc queries) | |||
A validated List which link to selected cells according to what is selected on the list | Excel Worksheet Functions | |||
How to generate a list of randomly selected numbers within a range | Excel Worksheet Functions |