VBA code for find value in another sheet, if yes then color it

Hi Experts

Need your help in understanding how it works in the below scenario. Sheet1 value should get matched in sheet2. if sheet 1 value is not matching with sheet 2 value then sheet1 value should get highlighted. I need this in VBA. in the below scenario, A2 cell should get highlighted. Please help me in this

Sheet1

A1 = 12
A2 = 13
A2 = 15

Sheet2

A1 = 15
A2 = 12

Please Login or Register  to view this content.

Try this:

Please Login or Register  to view this content.

Hi Jean,

Thats Awesome. Its working super.

Just have one doubt. How come it is active always. when ever there is change in the data, it is getting highlighted. Normally data will always get changed when we use declarations as for as i know.

Thanks