This is a question I'm sure has been asked numerous times before. I have two worksheets and I need to compare data. The first worksheet has 910 items on it, the second has 578. I need to do a compare and have the difference of 332 items highlighted. How do I go about doing so?

Then part 2. Just to satisfy my curiosity. How would I go about displaying that difference of 332 on a third worksheet?