| 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 |
| 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 | |||
Threaded Mode
