Hello
I want to use a macro similar to this one to change the colour of a cell when someone has made a change to a cell within one column only:
Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.ColorIndex = 5
End Sub
I am pretty new to the world of VBA and my hunch is that is requires a loop but I'm not sure how to write one. Any assistance would be appreciated!
I want to use a macro similar to this one to change the colour of a cell when someone has made a change to a cell within one column only:
Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.ColorIndex = 5
End Sub
I am pretty new to the world of VBA and my hunch is that is requires a loop but I'm not sure how to write one. Any assistance would be appreciated!