Trace Precedents/Range Finder etc

Hi guys,

I am having trouble figuring this one out. Maybe you can help me.

I have data on sheet1.
I have the formula on sheet2.

Is there a way to show the coloured 'range finder'/'cell reference' on sheet1 when I click on the formula in sheet2? (ie when you press F2 on a formula the coloured ranges are shown only if the data and formula are on the same sheet...is there a way to show these coloured ranges within the data when my formula is on a different sheet?).

Any help will be much appreciated.

Thanks,
Kind regards,

-Mick.

Does anyone know if this can be done?
Need a reply urgently...