Removing

This will remove the conditional formatting from rows 2 to 10 that contain the text "Remove" in column "H".

Sub RemoveConditionalFormatting() 
Dim lrowno As Long
For lrowno = 2 To 10
    If (Range("H" & lrowno) = "Remove") Then
        Range("A" & lrowno & ":G" & lrowno).ClearFormats
    End If
Next lrowno
End Sub


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext