Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use vlook to show the value of a cell using a formula | Excel Discussion (Misc queries) | |||
Is it possible? | Excel Worksheet Functions | |||
assign formula to another cell | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel |