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.

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.