Microsoft Office Forums - View Single Post - conditional formatting macro

Thread: conditional formatting macro

View Single Post

Old

09-19-2017, 03:05 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

Maybe one way could be...

Code:

Sub Macro1()
    Cells.SpecialCells(xlCellTypeBlanks).ClearFormats
End Sub

or

Code:

Sub Macro2()
    Cells.SpecialCells(xlCellTypeBlanks).FormatConditions.Delete
End Sub

Reply With Quote