LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default Conditional Formatting - How do I delete ALL rules?

Excel2007
One of my sheets of reasonable size (last cell used IK1389) all of a sudden
started to display and scroll very slowly (+30s to page fwd).
I found that there are 100s (maybe 1000s - too many to count) of conditional
formats which vaguely resembled one format that I may have entered some time
ago. - Anyway, I don't want them anymore.
I suspect that they could be responsible for the sluggish behaviour.
Now I also found that when i select the whole sheet, the "Manage Rules"
window shows the majority of these rules with an empty "Applies to".

For curiosity I tried to delete one of these rules but Excel appeared to be
frozen - I cancelled it via the task manager.

Questions:
1) How can I clear all conditional formatting from a sheet without having to
go rule by rule and without interfering with (ie keeping) all other
formatting on the sheet?
2) Where could these "Applies to = blank" rules come from?

Thanks for your help,
Michael
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting conditional formatting rules Chadwill Excel Discussion (Misc queries) 16 April 30th 23 03:43 AM
conditional formatting - order of rules Andy the yeti Excel Discussion (Misc queries) 0 February 18th 09 02:15 PM
Paste conditional formatting rules Ted M H Excel Discussion (Misc queries) 0 May 21st 08 06:48 PM
More than 3 rules of conditional formatting Mats K[_2_] Excel Discussion (Misc queries) 2 July 3rd 07 12:25 PM
I need 5 conditional formatting rules-excel only allows 3 das1997 Excel Discussion (Misc queries) 4 November 12th 05 02:33 PM


All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"