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 |:>)
 

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

Font is changing when editing a cell 0
F2 - NO color-coded precedents??? 2
Cell fill color in linked cells? 1
Retain cell background color when pasting between files 0
Formula Color Coding 5
press F2 to eval a cell, no color & no highlight 0
URGENT: Double Clicking Not Allowing Editing In Cell 2
Editing a formula 0

Top