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
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext