Comparing two sheets

[her.rockstar]

Hi, I have two worksheets that should be the same. The data on each sheet spans from A1:FF517

I would like to have a dynamic list that searches the entirety of both sheets and lists the cell where there is a difference. Does this sound possible, by either a formula, or VBA?

[jason.b75]

How about applying conditional formatting to one of the sheets to highlight the differences?

Conditional format rule, applied to the $A$1:$FF$517

=Sheet1!A1=Sheet2!A1

Set formatting as desired.

[her.rockstar]

You know, I think that will work great. I'll use a formula to supplement, ie: a count to at least point to the sheet. Thanks for the suggestion!