• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Too Many Conditional Formats...

S

skidragon02

New Member
I inherited a massive file with tons of sheets and formulas. Each sheet has over 30 conditional formats. Is there any way to remove a cluster of the conditional formats (but not all of them) at one time?
 
Good day skidragon02


You mean you want to remove from contiguous cells, if so select the block of cell and from the ribbon in the editing section choose clear/formats. Even if you select some cells with no formatting in your selection it will still be alright. If they are non-contiguous then just Ctrl click on the cells then do as above.
 
If your using XL2007+, you can use the CF manager to review all the rules and delete the ones you want.
 
bobhc: I am trying to only remove some of the CFs of an entire table.


Luke M: There are so many CFs per table that doing so would take a very long time.


Is there any faster way to do so without clearing all of the CFs?
 
If you know the exact ones, you can do it via macros, but it could be tricky to make sure you always get the right ones. Or, if the amount that you need is very few, perhaps you should just clear them all out, and then use a macro to rebuild? I'm not sure what would be best path for you situation.
 
You must log in or register to reply here.
Back
Top