compare lists, highlight matches

i have 2 columns, list "a" and list "b". i want to have any entry in list "a" that is also in list "b" to automaticly highlight.

the best example i could find online was
http://spreadsheetpage.com/index.php...al_formatting/
but i could not get it to work.

does anyone have any suggestions on how to achieve this?


The question I am posed with is the analysis of the use of some internal documents.
I have 2 document access reports that list the employee number and document name.
I am trying to see if the employees who accessed one document also accessed the other document.

Hello trixxnixon,

Welcome to the Forum!

It isn't clear to me what the problem is. If you have 2 columns of data to compare then the example you sited will work. You mention this...

I have 2 document access reports that list the employee number and document name.

Are these reports in Access or have they been imported to Excel?

Sincerely,
Leith Ross

i apoligize for the confusion, i am using an excell worksheet with two columns of data, not an actual microsoft access report


thank you!

here is a sample