Excel2007 Conditional Formatting Slow Performance Issue

[Michael F]

Has anyone else notice a drastic performance issue with Excel 2007's
conditional formatting?

I have a workbook and code that I wrote for XL2003 which has worked great
for a year, no hiccups or performance issues. However when I open the same
workbook and run the same macro in XL2007 it will either take an extended
amount of time to run or crash Excel 2007 all together. Even if the macro
completes when I move around the worksheet it takes 2,3, sometimes 5 seconds
to move between cells.

To make it bearable I have to remove all the conditional formatting from the
sheet, which isn't a permanent fix as the conditional formatting actually has
a purpose to highlight gaps between my data.

I've searched Microsoft but can't find any KB articles and I'm not paying
$300 to email my question to them. I'm hoping (wishful thinking, I know) that
someone at Microsoft may look at message board threads with a lot of activity
so if you're experiencing conditional formatting performance issues, please
reply to this thread just to let people know you have the problem.

Thanks!

 

[Bassman62]

Michael,

Although my files may not be as extensive as yours, I have not noticed a
significant decrease in performance going from 2003 to 2007.
I tested an amortization schedule that has 1550 rows of formulae and
conditional formatting.

Regards:
Dave

 

[gavin89]

I am experiencing the exact same issue.. although I am applying Conditional Formatting on some 3000 cells....
I guess since you had the same problem over a year ago, nobody is doing anything to fix it.. mehhh...