Cells referenced in formula bar not highlighted in worksheet
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
"squall" wrote:
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.
|