dparteka
Member
The code below deletes conditional formatting in the entire row if "OPEN" appears in column-C, I'm trying to figure out how to get it to delete only in Column-D. For example, if C5 and C8 are the only ones that have “OPEN” in them then CF would be deleted in only D5 and D8. Any help will be very much appreciated, thanks for looking.
Code:
Sub DeleteConditionalFormat()
Dim Rng As Range
Dim SubRng As Range
Dim SubRow As Integer
Set Rng = Range("C5:C" & Cells(Rows.Count, "C").End(xlUp).Row)
For Each SubRng In Rng
If SubRng = "OPEN" Then
SubRng.EntireRow.FormatConditions.Delete
End If
Next SubRng
End Sub