Formula Cell color limitation
 

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+B2 9+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+B2 9+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

Formula Cell color limitation
 

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

=SUM(B3:B34)

Regards,
Paul


"fenixdood" wrote in message
...
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+B2 9+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+B2 9+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

Formula Cell color limitation
 

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

"fenixdood" wrote in message
...
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+B2 9+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+B2 9+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

Formula Cell color limitation
 

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,

"David Biddulph" wrote:

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

"fenixdood" wrote in message
...
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+B2 9+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+B2 9+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

Formula Cell color limitation
 

There are several limits of 32 in pre XL 2007 versions:
http://www.asap-utilities.com/excel-...tegorie=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
--
Brevity is the soul of wit.


"fenixdood" wrote:

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,

"David Biddulph" wrote:

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

"fenixdood" wrote in message
...
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+B2 9+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+B2 9+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

Formula Cell color limitation
 

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

"Dave F" wrote:

There are several limits of 32 in pre XL 2007 versions:
http://www.asap-utilities.com/excel-...tegorie=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
--
Brevity is the soul of wit.


"fenixdood" wrote:

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,

"David Biddulph" wrote:

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

"fenixdood" wrote in message
...
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+B2 9+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+B2 9+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

Formula Cell color limitation
 

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

Dave
--
Brevity is the soul of wit.


"fenixdood" wrote:

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

"Dave F" wrote:

There are several limits of 32 in pre XL 2007 versions:
http://www.asap-utilities.com/excel-...tegorie=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
--
Brevity is the soul of wit.


"fenixdood" wrote:

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,

"David Biddulph" wrote:

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

"fenixdood" wrote in message
...
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+B2 9+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+B2 9+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

Formula Cell color limitation
 

Yes. You have hit the limit.

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


Gord Dibben MS Excel MVP

On Tue, 14 Nov 2006 09:36:02 -0800, fenixdood wrote:

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,

"David Biddulph" wrote:

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

"fenixdood" wrote in message
...
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+B2 9+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+B2 9+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