| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Limit of color-coded cell references editing a formula.
When trying to F2 edit a cell that contains a very long formula, over 100
individual cell references, the color-coding feature is not working. Is there a limitation to the number of cells that will appear color-coded when editing a formula. |
|
#2
|
|||
|
|||
|
Hello-
Excel has a general limit of 56 colors in a workbook, which I assume applies to your issue as well. Regards |:) "u2sparky" wrote: When trying to F2 edit a cell that contains a very long formula, over 100 individual cell references, the color-coding feature is not working. Is there a limitation to the number of cells that will appear color-coded when editing a formula. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace range names with cell references? | Excel Worksheet Functions | |||
| Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| copy paste cell character limit | Excel Discussion (Misc queries) | |||
| Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) | |||
Linear Mode
