View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default 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