Forum

Notifications
Clear all

delete multiple conditional formatting rules

3 Posts
2 Users
0 Reactions
2,257 Views
Katherine Williams
(@katherinew)
Posts: 17
Eminent Member
Topic starter
 

I have TONS of the same conditional formatting rules that I want to delete.  Is there a way to delete multiple rules at the same time or do I have to select and delete them one at a time?

 

Thank you!

 
Posted : 07/08/2020 5:10 pm
(@mynda)
Posts: 4761
Member Admin
 

One at a time I'm afraid, Katherine 🙁 Unless you can write some VBA to automate it, or you could select the cells > Home tab > Clear formats.

 
Posted : 07/08/2020 6:32 pm
Katherine Williams
(@katherinew)
Posts: 17
Eminent Member
Topic starter
 

Ugh!  Thank you Mynda, that's what I was afraid of, lolol!

 
Posted : 11/08/2020 10:33 am
Share: