View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
squall squall is offline
external usenet poster
 
Posts: 1
Default Cells referenced in formula bar not highlighted in worksheet

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.