VBA Code to Select the whole sheet, delete Cond Format

[MFish]

Hi there,

I have a VBA code that I use to delete CF, conditional format, and then reapply that same CF once the macro is done deleting/inserting a row. Here it is...

    With Worksheets("Input new run").Range("B7:T10000")
        .FormatConditions.Delete
    End With

'Add the CF of alternating unique ID's

    With Range("B7:T10000").FormatConditions.Add( _
        Type:=xlExpression, _
    Formula1:="=AND(ISODD($A7),ROW()>1)")
    
        .Interior.Color = RGB(178, 178, 178)
        
    
    End With

My question is... How do I actually delete the WHOLE spreadsheet of Conditional formatting, maybe only Columns B:T?, and reapplying a CF that states if cell is blank then please fill in with RGB(242,242,242).

 

[MFish]

Solved, to the best of my knowledge... I just wrote this...

With Worksheets("Input new run").Range("B7:T10000")     .FormatConditions.Delete
    With .FormatConditions.Add(Type:=xlExpression, Formula1:="=B7=TEXT(,)")
        .Interior.Color = RGB(242, 242, 242)
    End With
End With