conditional formatting macro

ewso · #1 09-19-2017, 06:06 AM

Is there a macro that can remove the conditional formatting from all blank cells in a worksheet?

thanks

jeffreybrown · #2 09-19-2017, 03:05 PM

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

ewso · #3 10-05-2017, 12:10 AM

The second code worked! Jeffrey thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting Macro	grexcelman	Excel Programming	1	01-10-2015 04:45 PM
Conditional formatting	marif300	Project	9	09-23-2014 07:23 AM
Conditional formatting that ignores other formatting rules	info_guy2	Excel	1	07-03-2014 10:07 AM
Conditional Formatting	jdc15371	Excel	2	06-26-2014 06:34 AM
Conditional Formatting and/or Macro for Character Insertion?	MonOverArchIng	Word	2	01-11-2013 02:48 AM