VBA- Cell colour change based on cell value change one column only

[nlbenz]

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!

 

[Z51]

No need for a loop, just check that the Target cell (the cell that was acted upon) is in that specific column. Let's say that column is C, then:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
Application.EnableEvents = False
If Not Intersect(Target, Range("C:C")) Is Nothing Then Target.Interior.ColorIndex = 5
Application.EnableEvents = True
End Sub