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
Bookmarks