Conditional formatting size limit

P

Picman

Is there a limit to the number of cells that can contain conditional
formating in one worksheet?
 
L

Luke M

(Verified up to 2003)
No, you can conditionally format every cell in the sheet. (although this
could cause your computer to slow down, depending on available memory.

See "Excel specifications & limits" for further details, as there are limits
on nyumber of cell styles and number custom formats.
 
P

Picman

I took a look at the "Excel specifications & limits" page and there was
nothing that seemed to be an issue in this case.
Here is a little better description of the issue that I encounter.
When I try to save my file (Excel 2003) I receive an error message that
states:

"Excel could not save all the data and formatting you recently added to
filename.xls.

To return to your workbook without saving click Cancel.
If you want to continue saving changes without repairing the problem, click
OK.


I've tried to hit the help button but get nothing but a blank page.

I've tried to remove all of the formatting (bold, borders etc.) but nothing
seems to work.

The whole workbook is only about 12mb. Approx 8400 rows by 20 columns with
every seventh row containing a conditional format in 14 of the cells across.
The conditional format is simple as well, if the number is lass than 0 format
the value to be bold and red, and thats it. I don't understand why Excel is
having any difficulties handling this. Got any ideas? Please.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
Filter criteria in reference cells 2
Conditional fomat series 2
Excel Conditional Formatting 1
Excel VBA 1
View Conditional Formats on worksheet? 4
Conditional Formatting 1
Excel Conditional Formatting Removal 7

Top