First decide which sheet is the one to be the "master" and which one you want
to find duplicates in. Let's say the postcodes you want to find duplicates IN
are on Sheet2, and you want that sheet to be compared against postcodes in
Sheet1. Let's put all the postcodes in column A for this example.
On Sheet1, you'll have to name the range with the codes to check. Let's say
A1:A1000 is your range, highlight it and enter Postcodes into the Name box
(just to the left of the formula bar).
Now, we'll use conditional formatting on the cells on Sheet2. Highlight the
ENTIRE range you want to check for duplicates. Click FORMAT > CONDITIONAL
FORMATTING and enter this for the first condition:
FormulaIs: =MATCH(A1,Postcodes,0)
Then click FORMAT and set the highlighting you want, font or pattern (for
background). Click OK.
Now the postcodes on Sheet2 that are in the range from Sheet1 will change
color to match your settings.
Will this work for you?
ostcode) between different sheets, any suggestions?