Checking for differences

[james_tang]

Hi all,

I have two worksheets in a workbook, each with a bunch of data types (i.e. Text, Number, Currency, Percentage) and I want to check if these two sheets are the same or not.

Is there any way to highlight on one of the sheets the cells that are different in terms of value (but not formatting i.e. colors)?

Thanks.

[Phillycheese5]

I'm not sure if this is the best way, but it's a way....if you insert another sheet and start in cell A2 with a formula like this:
=if(Sheet1!A1=Sheet2A1,"","1")
The result will do nothing if the data is equal and put a "1" in the cell if there is a difference. The idea of starting in cell A2 on the check sheet is so that in cell A1 you can put a SUM formula =SUM(A2:Z500) which will tell you the number of differences there are in the data range. Granted you'd have to move around the check sheet to find out exactly which ones are off, but it's a start.
Hope that helps.
Phillycheese