Conditional formatting makes large spreadsheet unusable.

[kat35601]

Conditional formatting makes large spreadsheet unusable. The Condition is: If value less than 0 the make cell background red. The range is A1 thru CR500 do you thing doing it in VBA would work and not kill the spreadsheet or would it be the same? What would the vba code look like?

 

[etaf]

do you have lots of formulas in the spreadsheet
I have a spreadsheet range larger than yours for a colour and its fine 0 but few formulas

If you remove the conditional formatting formula
Does it improve

Is just 1 conditional formatting formula in the RANGE A1 to CR500
A1<0

 

[kat35601]

Yes when I remove the conditional formatting the spreadsheet works fine. if any cell <0 than change background to red.
I have tried this on different machines and get same results.

 

[Fluff]

Is the applies to range A1:CR500 or is it something like A:CR

 

[kat35601]

it shows A$:CR$

 

[Fluff]

In that case change it to $A$1:$CR$500 or if needed down to row 2000.
It's always best to avoid whole columns in CF