Highlight duplicate entries from multiple sheets

Hy all!

I am trying to highlight duplicate entries from different worksheets using conditional formating and is not woking. I've found this formula =NOT(ISERROR(VLOOKUP(A1;bannedworkers;1;0))) but it not works ; i'm using excell 2003.
I have two worksheets;in the first sheet on the first column (A) named bannedworkers I have a list of banned workers and in the second sheet on the first column (A) I have a list with workers. I want that when I type a banned workers name in the second sheet, first column, the cell to highlight in the color chosen in the conditional formatting.
I've used this formula in conditional formating but it not works =NOT(ISERROR(VLOOKUP(A1;myColumn;1;0))).

What is the problem???

The formula is from here (they say it works) http://www.computing.net/answers/off...ries/5159.html

I've attached a sample of what I want to do!!!

Hi,

Change the formula to

Please Login or Register  to view this content.

and drag down or copy paste the formats

Originally Posted by aravindhan_31

Hi,

Change the formula to

Please Login or Register  to view this content.

and drag down or copy paste the formats

I've used your formula and still not working.

Please try to modify the exel file atached

Hi change the formula to

=A2=(VLOOKUP(A2,bannedworkers, 1, 0)) it will work.

I have attached the file.

Originally Posted by aravindhan_31

Hi change the formula to

=A2=(VLOOKUP(A2,bannedworkers, 1, 0)) it will work.

I have attached the file.

The funny thing is that I don't notice the difference between my excel file and yours (see attachment) but yours it's working, I don't know why but it does.

Also when I click to see the formula in conditional formatting in your file it's still my formula =NOT(ISERROR(VLOOKUP(A8, bannedworkers, 1, 0))) not yours
=A2=(VLOOKUP(A2,bannedworkers, 1, 0)) see attachment's . I don't understand why ????

Problem solved!

Bouth yours and my formula where correct all I had to do was to define a name for the bannedworkers column (formulas-define name).

Also this formula works

=COUNTIF(bannedworkers,A2)

Thank's for your help!