Forum

Notifications
Clear all

delete multiple conditional formatting rules

3 Posts
2 Users
0 Reactions
9,493 Views
Katherine Williams
(@katherinew)
Posts: 21
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: 4783
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: 21
Eminent Member
Topic starter
 

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


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