Identifying cell references in a formula ADV

[HappyAuditor]

Hi everyone,

I am working with some fairly long formulas and I am looking for a way to highlight those cells AND work in the document. I know you can click in the cell and it will highlight them, but if you click off the cell the highlights go away. Is there a way to keep them highlighted?

Thanks!

 

[HappyAuditor]

Actually, I just found it! In the formulas tab, click the trace precedents button!