Hi
yes there's a limit for formatings. See:
http://support.microsoft.com/default...b;en-us;213904

--
Regards
Frank Kabel
Frankfurt, Germany

"Marty" schrieb im Newsbeitrag
...
Hiyall:

I'm running Excel 2002 on XP Pro. I'm dealing with a
workbook wherein one of the worksheets will have about
3000 rows and around 50 columns. I'm trying to apply
validation (list of three possibilities from a list) and
conditional formatting (background color change depending
on which of the three possibilities is chosen) to 20 of
the 50 columns.

After I get about halfway through the formatting, when I
go to save the workbook, I get the following message box:

--------------------------------------------------
Excel could not save all the data and formatting you
recently added to {filename}.

- To return to your workbook without saving click Cancel.
- If you want to continue saving without repairing the
problem, click OK.
- For information about repairing the problem, click Help.

[three buttons: OK (default), Cancel, Help]
--------------------------------------------------

When I click help, the help screen comes up but it is
BLANK.

It acts almost as if there is a LIMIT on how much
validation and/or conditional formatting a worksheet can
tolerate.

Has anyone ever encountered this? Any ideas what handy
tips might be on that elusive help screen? Any REAL help
(not blank) will be appreciated.

Thanks,
MARTY