Conditional Formatting Problems HELP!

[Greg Ivins]

I used conditional formatting for the first time to display colors i
cells based on the value of the cell. Everything works fine excep
when I try to save I get the message "Excel could not save all the dat
and formatting you recently added to nnnn.xls".

Microsofts kb has an article that says you cannot exceed 2,050 row
(Q215783), but I certainly don't have nearly that many rows. I do hav
a pretty large number of cells with conditional formatting and wonde
if there is some other limitation that I can't find. Everything els
about this sheet is very plain stuff.

Can anyone help me

 

[Dave Peterson]

I've never seen this error, either.
When you applied the Format|Conditional formatting, did you apply similar
conditional formatting one cell at a time or did you do a range (like A2:a999)
at once?

It might be worth trying to do multiple cells at a time (if your data allows
this).

Another article about formatting that could have applied:

XL: Error Message: Too Many Different Cell Formats
http://support.microsoft.com/default.aspx?scid=kb;en-us;213904

(maybe it wasn't the conditional formatting that caused the error.)