Cells referenced in formula bar not highlighted in worksheet

S

squall

When adding many cells throughout a worksheet, the cells referenced in the
formula are not highlighted. They are highlighted when using shorter
formulas, but with long formulas the cells are not highlighted. Is there a
limit on how many cells can be referenced in a formula for them to be
highlighted.
 
E

Elkar

Excel will only highlight 32 total cell references in a single formula. If
there are 33 or more, then none of the references will be highlighted.

HTH,
Elkar
 

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

Change cell color if used in a formula? 0
the forumula bar is not visible 2
Add value of (1) to a selected cell or cells 2
EXCEL 2003*FORMULA TO HILIGHT SPECIFIC CELLS WITH TRUE RESULTS? 6
Paragraph numbering in Word 1
Highlighted 6
More than selected rows being highlighted 0
Excel 2003 cell references - >32 refs - no more highlighting? 4

Top