Option Explicit
Private Sub Worksheet_Change(ByVal c As Range)
If c.Column <> 10 Or c.Count > 1 Then Exit Sub
If Not Intersect(c, Range(Range("j4"), Range("j4").End(xlDown))) Is Nothing Then
If c = "ok" Then c.Offset(, -9).Resize(, 9).Interior.Color = 5287936
If c = "Not ok" Then c.Offset(, -9).Resize(, 9).Interior.Color = 255
If c = "pending" Then c.Offset(, -9).Resize(, 9).Interior.Color = 49407
End If
End Sub