This is the Conditional Formatting tag.

Excel iconVBA icon

Quickly Clear Conditional Formatting

Here is a simple sub that deletes conditional formatting from a selection. The code does some prelim checking to see that it is actually acting on a range, and it mimics Excel's usual behavior (like a good VBA procedure should, if I may say so) by acting on the entire worksheet if you only select a single cell. However I recommend just selecting the range before you run the code.

Continue Reading »

Random Data Generator