Remove All Condition Formatting

D

Darrell Lankford

I have a worksheet with all kinds of different forms of condition
formatting. Can anyone tell be how to remove all condition formats on
a sheet and still keep all other formats as is?

Darrell
 
D

Darrell Lankford

I figured it out. Just highlight all and delete all conditions even
thou they are not showing on the condition format box.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Condition formatting problem 3
If Condition 4
How to copy the new Excel 2007 conditional formats 4
How to verify if a range (or a cell) is contained in another range 4
Evaluating Conditional Formats 3
Apply cell formatting using VBA 1
Indirect in Conditional Formatting 7
Conditional Formatting Based on Cell Values for more than 3 condit 7

Top