I need to highlight changes in a workbook but, in addition to the cell that's changed, I need to highlight a cell in another worksheet. For example, Sheet1 cell B4 equals 2 and Sheet2 cell E4 contains =Sheet1!B4. When I change the 2 to a 3, the cell in Sheet1 is highlighted. Sheet2 shows the new value but is not highlighted because the content of the cell, the formula, has not changed. I understand the "why" but I don't know how to make it do what I want.
Track Changes from the menu bar doesn't help and I know how to Conditional Format depending on a cell value but not how to apply it based on a change. So far, I've copied the following code I found here to each sheet (14 sheets total) but it only highlights the cell itself.
<CODE>
Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.Color = vbCyan
End Sub
</CODE>
Any insight will be greatly appreciated. Thanks!
JCastro
Track Changes from the menu bar doesn't help and I know how to Conditional Format depending on a cell value but not how to apply it based on a change. So far, I've copied the following code I found here to each sheet (14 sheets total) but it only highlights the cell itself.
<CODE>
Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.Color = vbCyan
End Sub
</CODE>
Any insight will be greatly appreciated. Thanks!
JCastro