Home VBA Hightlight cells based on cell content
 I'm working on getting this macro working. I want it to, for every row, when "Late" is entered into column C, to highlight the cell 2 spaces to the left and Range of cells 3 spaces to the right through 43. So example is C4 contains "Late", highlight A4 and F4:AW4. Same goes for the word "Hold" just a different color. Private Sub Highlight_Condition(ByVal Target As Range) Dim lastRow As Long Dim cell As Range Dim i As Long With ActiveSheet lastRow = .Cells(.Rows.Count, "C").End(xlUp).Row Application.EnableEvents = False For i = lastRow To 1 Step -1 If .Range("C" & i).Value = "LATE" Then Debug.Print "Checking Row: " & i .Range("A" & i).Interior.ColorIndex = 39 .Range("F" & i & ":AW" & i).Interior.ColorIndex = 39 ElseIf .Range("C" & i).Value = "HOLD" Then .Range("A" & i).Interior.ColorIndex = 43 .Range("F" & i & ":AW" & i).Interior.ColorIndex = 43 Else .Range("A" & i & ":AW" & i).ClearContents .Range("F" & i & ":AW" & i).ClearContents End If Next i Application.EnableEvents = True End With End Sub