Find referrence in formula

[RicardoB]

Hi, friends!
I need your help again...
For example:
I have one formula in cell B3, that is =A2+5*3+4
I have one formula in cell B4, that is = A3+5*3+4

Is there any way to identify (using formula) that the cell in B3 is referred to cell A2 and the B4 is referred to cell A3? The list of formula is too big, and it will be hard to look into each one...

Thank you!!
Regards,
Ricardo

 

[iliace]

Not so much using formula, but you can use Tools->Formula Auditing->Trace Precedents to visually see which cells are referenced.