Limit of color-coded cell references editing a formula.

U

u2sparky

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.
 
C

CyberTaz

Hello-

Excel has a general limit of 56 colors in a workbook, which I assume applies
to your issue as well.

Regards |:>)
 
Top