ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional Formating Slowdown (https://www.excelbanter.com/excel-discussion-misc-queries/83006-conditional-formating-slowdown.html)

addy81

Conditional Formating Slowdown
 
Hey, I was onto this site a few days ago and downloaded a patch or some sort
of expansion for Excel. It was to allow up to 30 sets of conditional
formatting on the same sheet. Works great, thanks to those who posted it,
but when I have now gotten my page running, it is extremely slow. I have 9
conditional formats running in each of several different cells, but no more
than those 9 on each. Is there any setting I can do to speed this up, or any
code that I could change. I'm not afraid of Visual Basic. Or could it
possibly just be my computer. My machine isn't amazing, but its only 3 years
old so I figured it should be ok. Also I think that the version of Excel I
am using is 2000 so that could have something to do with it. Any help would
be greatly appreciated. Thanks.


All times are GMT +1. The time now is 07:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com