Quantity of Conditional formats limit?
 

In excell 2007: A spreadsheet I use has a tab with ~100,00 rows of data. One
column in that tab was conditional formatted (when cell = specific text). It
would take ~5min to do a sort of any column and ~1.5min just to open the
spreadsheet. On two different PCs with vastly different specs and operating
systems it took almost exactly 1.5min to open the file. The progress bar
would get to ~95% and freeze for the next ~1.25min until it seemed to give
up/time out and open.

Removing the formatting makes the spreadsheet fast and normal, is there a
way to have my formatting and reasonable operating speed? Tried turning off
auto calulation but that has no effect on formatting it seems probably
because its not like a normal formula in a cell.