The following code (which I found on the forum) is almost what I need. If a change occurs in the specified cell, here L10, then, depending on the contents of the cell, it will colour the cell. How do I change this to specify a range of cells - for example, to check if the change occurs in any cell in the range L10:L200?
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$L$10" Then Exit Sub
If Target = "Done" Then Target.Interior.ColorIndex = 6
If Target = "Pending" Then Target.Interior.ColorIndex = 45
End Sub
Bookmarks