Auto Change Color when cell value changes

[danjw_98]

Is there a way to automatically change the color of a cell when the value changes? thanks...


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

 

[VoG]

That should really be

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

Isn't it working?

 

[danjw_98]

thanks!!! that worked