Automatically cross checking two spreadsheets

[daveb1]

I have two excel spreadsheets which for audits are logged by two separate departments. If the work is being logged correctly the spreadsheets have the same information on both, but we need a way of checking both documents and highlighting anything that is on one spreadsheet and not the other. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
The spreadsheets have columns for Name, reference number, and agent<o></o>

 

[PCL]

What about a conditional format?