Formula Cell color limitation

[Guest]

Hello,

I have a user with an coloring issue with formulas. If we add more than 32
cells in a column the colors do not turn on. If only 32 cells all cells are
color coded.as the example below: all cells are colored in edit mode

=B3+B4+B5+B6+B7+B8+B9+B10+B11+B12+B13+B14+B15+B16+B17+B18+B19+B20+B21+B22+B23+B24+B25+B26+B27+B28+B29+B30+B31+B32+B33+B34

This formula with 33 cells included do not get colored in edit mode.
=B3+B4+B5+B6+B7+B8+B9+B10+B11+B12+B13+B14+B15+B16+B17+B18+B19+B20+B21+B22+B23+B24+B25+B26+B27+B28+B29+B30+B31+B32+B33+B34+B35


Is this a limitation with excel. the number 32 leads me to believe this. I
cannot find any info on this issue. I am not using code to do this just the
gui itself..

Any help would be awesome..
Thanks in Advance.

Ron

 

[PCLIVE]

I'm not sure of a color limitation, but why don't you simplify your formula?

=SUM(B3:B34)

Regards,
Paul

 

[David Biddulph]

If your formula is trying to add the numbers, why don't you use =SUM(B3:B35)
?

 

[Guest]

I understand your answer... but this was just a test. My user wants to be
able to visually link all cells he is working with..Your answer of course is
a correct way to do it. THe way the user create his workbook needs the cell
individually colored. And as I stated earlier seems to be a limit on the
color coding,

 

[Guest]

There are several limits of 32 in pre XL 2007 versions:
http://www.asap-utilities.com/excel-tips-detail.php?categorie=9&m=90

While your scenario is not mentioned specifically in the link I give, it's
probably safe to assume that you've hit an XL limit.

Dave

 

[Guest]

Thanks a bunch Dave.. This is what I anticipated hearing..the 32 number kinda
gave it away...Do you know by chance if 2007 has the same limits?.

Ron

 

[Guest]

It probably does not. This may give you some answers:
http://blogs.msdn.com/excel/

Dave

 

[Gord Dibben]

Yes. You have hit the limit.

I thought it was 34 but haven't tested lately and memory dims.


Gord Dibben MS Excel MVP