Hiighlight the changed cells which are changed with the linked wookbook?

Sheet a in workbook A is linked with sheet b in workbook B by "Vlookup" function formula. The Changes in Sheet b will result in cooresponding changes in sheet a. There are a lot data in both sheets. Can we have a macro to highlight the changes cells in sheet a by changing the cell color?
I try to use "sheet_change" and "sheet_calculae", but failed.

Private Sub Worksheet_Calculate()
Target.Interior.ColorIndex = 5
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.ColorIndex = 5
End Sub

Please help write a VBA!
THANKS

no one answers?

Who can Help me?

I really appreciate if someone can give me a solution!

Maybe it is a hard question.

Sad, I am sad. I really need help.

Maybe it is a really difficult program.

No one can help?

I am too sad! down

On which sheet do you highlight the change

highlight the change in sheet A.