Comparing spreadsheets question
 

I am trying to use conditional formatting to compare two spreadsheets, let's
call them sheet 1 and sheet 2. What I want to do is look at each row in
column A in sheet one and see if that cell appears in column A in sheet 2
(or any column for that matter, but let's use A as an example here). If that
cell also appears in sheet 2, I would like that cell to highlight on sheet 1.


I appreciate any help someone can give me in this matter.