Showing posts with label conditional formatting. Show all posts
Showing posts with label conditional formatting. Show all posts

Thursday, April 14, 2011

Excel VBA: Remove All Conditional Formatting From Sheet

At times you may experience issues with macros when having lots of conditional formatting rules on a sheet. Here's the magic with which you can remove all conditional formatting rules from a sheet:

Sheets("MySheet").Cells.FormatConditions.Delete