conditional formatting macro

		Microsoft Office Forums > Microsoft Excel > Excel Programming
conditional formatting macro

09-19-2017, 03:05 PM

jeffreybrown jeffreybrown is offline

Windows Vista conditional formatting macro

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

Maybe one way could be...

Code:

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

Code:

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

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:54 PM.