Solved How to compare similar, but different worksheets

March 27, 2015 at 18:24:46
Specs: Windows 7
I want to compare two worksheets to see what changed... what came off, what went off, what changed

Many different columns, but just need result of change for a few

See More: How to compare similar, but different worksheets

Report •

March 27, 2015 at 19:28:30
✔ Best Answer
I'm not quite sure what you are trying do. Perhaps you could supply a little more detail, maybe with some example data to show a few "changes".

One simple method (although without more detail I'm not sure if this will work for you) might be to use the following formula as a rule for Conditional Formatting to fill cells that match (or don't match) with a specific color.

=A1=Sheet2!A1 to highlight cells in Sheet 1 that match the corresponding cell in Sheet2


=A1<>Sheet2!A1 to highlight cells that don't match

If you need help setting up Conditional Formatting, just let us know.

If you are going to post example data, please click on the following link and read the instructions on how to post data in this forum. Please be sure to include Column letters and Row numbers. Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question