Compare data between two sheets

Dear Gurus,

I've got the issue to compare the data from two sheet. Could you please help on this? My data in two sheet wit hthe same header but the data when input are not match exactly. What I need is to point out the different is where for each sigle row e.g they are different only in one cell vs. other or event two And if they are match perfectly we will color them with green background for example.

Best regards,
TQV

Re: Compare data between two sheets

Dear Dave,

Thnaks for your help but I'm not successful. What I want is to search one of row in sheet 1 to find the same in sheet 2. In case it is match bold all of them with green back ground. If not(match with most of cells but 1 or 2 are diff.), highlight those different cells in that row in both two sheet.
Can we have the solution to bring all of them into one sheet data where the same will be unique; And those are not exact 100% will be high light those cells are diff and add one more column with name of sheet to know where they come from.
Thanks.
TQV