Disregard The Conditional Formatting Rules of A Cell

[Ark68]

I have a dataset whose cells are formatted conditionally. However, over the course of my VBA application, the values of these cells may change change which in turn changes the rules of the conditional formatting.

For example, a cell contains a person's name, Peter. A conditional format rule says if that cell not equal <> "Peter", to shade the cell grey. The background is unchanged as long as the cell remains equal to Peter.

At a point in the code, the value Peter, changes to a time. As the cell no longer equal's Peter, the cell becomes shaded. I don't want it to. I put in my code a line to change the background to white, but I think the conditional formatting trumps that.

For t = sr To ilrdata
        If .Range("Q" & t) = pristaff Then
            .Range("Q" & t) = Format(Application.VLookup(.Range("A" & t), rcore, 61, False), "h:mm")
            .Range("Q" & t).Font.Color = vbBlack
            .Range("Q" & t).Font.Size = 6
            .Range("Q" & t).Interior.Color = RGB(255, 255, 255)
        End If

How can disable the conditional formatting of that cell?

 

[Ark68]

.formatConditions.Delete

 

[Special-K99]

Just set up two conditional formats, no VBA required
One to check for Peter, shade cell grey
One to check for a time, format as required