Limit of color-coded cell references editing a formula.

G

Guest

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

Guest

Hello-

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

Regards |:>)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

F2 - NO color-coded precedents??? 2
Formula Color Coding 5
Cell fill color in linked cells? 1
URGENT: Double Clicking Not Allowing Editing In Cell 2
hit F2, want the color coded formula to appear in formula bar not 1
Editing a multi-line formula 3
Change color of answer 5
double click cell to show formula references 1

Top