Detecting dupicate items on another worksheet.

[megnin]

I'm currently using this formula in Conditional Formatting to highlight duplicate part numbers in column B of one worksheet: =COUNTIF($B$2:$B$2000,b2)>1

I've added a second worksheet for a different region, and want to detect duplicate entries from the first worksheet as well, i.e. if a number is entered on worksheet #2 I want to highlight it if it already exists on worksheet #1 or on #2.

Thanks in advance

 

[SkipVought]

Hi,

On SHeet 2, you could do...

=OR(COUNTIF($B$2:$B$2000,B2)>1,
COUNTIF(Sheet1!$B$2:$B$2000,B2)>1)

Hope this helps Skip,
SkipAndMary1017@mindspring.com