Conditional Formatting Clear From Entire WorkBOOK

[tjscott0310]

We run a real estate business and each transaction is a tab in a workbook. There are a few hundred built up over the years and the file is getting too large.

We would like to move older ones to an Archive Workbook for that year. It's painfully slow. I am pretty sure the conditional formatting is the culprit.

How can I clear the conditional formatting from the entire workbook in one fell swoop? Not just one sheet at a time?

I am using Excel 2019 as part of Office 365 Small Business

Thanks,

 

[tjscott0310]

Try

For Each ws In ThisWorkbook.WorkSheets

You may have sheets that are not worksheets.

Worked perfectly. I had two charts in there somewhere. Thanks! Merry Christmas.