Compare 2 excel sheets in same workbook

[natachag]

Hello, I have 2 excel sheets in 1 workbook. Sheet 1 is the original version and sheet 2 is the updated version. I would like to compare both. What I'd need is a VBA that will highlight what has been added or changed from sheet 1 to sheet 2. The highlights would need to appear on sheet 2. Just a simple yellow highlight on the words that are new or different on sheet 2.

I have no knowledge and no idea how to do this. All I know is that I can past a macro in ALT+ F11 and run it. So if you could give me a code that I don't need to change at all ( because I wouldn't know how to ) ) Thank you so much for your help, I feel helpless :/

Thank you <3

 

[Special-K99]

Try conditional formatting with the formula

=(Sheet1!A1<>Sheet2!A1)
format as required
and copy to other cells

 

[natachag]

Where should I paste this ? I'm so sorry this must be so basic ...

 

[Special-K99]

Select a cell or possibly select all cells

Home tab, Conditional formatting, New Rule, Use a formula to determine which cells to format
and enter the formula there

You MAY need to insert a $ after the As to get it to work