Conditional Formatting

  • Thread starter Thread starter Frick
  • Start date Start date
F

Frick

I have this problem with conditional formatting. I used it to place a pattern in each cell where
the formula returns a 0. Problem is that it seems that there is a limit as to how many excell will
allow. When I go to save the worksheet, Excel returns an error. It doesn't say what the error is
but it cleraly is the conditional formatting. It does save the sheet but when I open it, it only
have the conditional formatting up to the maximum and then everything else is blank.

So, the question! Is there another way to accomplish placing a dot pattern in a series of ranges
where the formula returns 0?

Thanks for all help.
 
What's the exact error message? If it only occurs on Save, then it's
very unlikely to be related to Conditional Formatting. A CF error
will occur as you try to apply an incorrect CF.
 

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

Back
Top