#1
|
|||
|
|||
conditional formatting macro
Is there a macro that can remove the conditional formatting from all blank cells in a worksheet?
thanks |
#2
|
|||
|
|||
Maybe one way could be...
Code:
Sub Macro1() Cells.SpecialCells(xlCellTypeBlanks).ClearFormats End Sub Code:
Sub Macro2() Cells.SpecialCells(xlCellTypeBlanks).FormatConditions.Delete End Sub |
#3
|
|||
|
|||
The second code worked! Jeffrey thanks
|
Thread Tools | |
Display Modes | |
|
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 |