Highlight changes every where

[ahmedmirza]

Dears, Is there a way of having changes tracked for example if I delete the contents of a cell A5, the cell itself and all those dependants should be colored PINK. Thanks

 

[Domski]

Not without some pretty complex VBA.

Dom

 

[VoG]

Take a look at Tools > Track Changes.

 

[ahmedmirza]

The Track Changes function in excel just puts a comment and only on the cell changed not on the dependants...

Looking for more replies

 

[ahmedmirza]

Is it that difficult .. ??

 

[Sal Paradise]

Is it that difficult .. ??

Yes.

 

[Sal Paradise]

Okay, I lied slightly. Right click the worksheet and go to 'View Code':

Dim LastFormula As String

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Formula <> LastFormula Then
        Target.DirectDependents.Interior.ColorIndex = 26
    End If
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    LastFormula = Target.Formula
End Sub

If you want the dependents of dependents, then switch 'DirectDependents' to 'Dependents'

 

[ahmedmirza]

Thank you very much

This did work, for some reason, when i was trying to undo the change, I couldnt....

 

[Sal Paradise]

That's because it's a macro. You can't undo macros.