Sub Highlight_Row()
Dim ws As Worksheet: Set ws = Sheets("Overdue Traing Compliance") 'check your spelling
Application.ScreenUpdating = False
With ws
.AutoFilterMode = False
.Range("K2:K" & .Range("K" & Rows.Count).End(xlUp).Row).AutoFilter 1, 1
.Range("A3:G" & .Range("K" & Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeVisible).Interior.ColorIndex = 3
.AutoFilterMode = False
End With
Application.ScreenUpdating = True
End Sub
Sub Unhighlight_Row()
Dim ws As Worksheet: Set ws = Sheets("Overdue Traing Compliance") 'check your spelling
ws.Range("A3:G" & ws.Range("K" & Rows.Count).End(xlUp).Row).Interior.ColorIndex = 15
End Sub
Bookmarks