Highlighting Referenced Cells in Separate Worksheet

I've scoured Google and asked around and can't seem to find the answer. Is there a way (third party app or VBA) to highlight referenced cells from a formula in one worksheet in another worksheet within the same workbook?

I oftentimes open up diff. worksheets on different screens and have to manually trace cells from a formula because Excel will only highlight cells referenced on the same page.

Any help would be greatly appreciated.

Thanks

Instead of referencing to ranges you need to give name of the range and reference to a name.

Example.

Instead of:
=ISNUMBER(MATCH(A1,Sheet2!$F$6:$F$21,0))

Put some name for range Sheet2!$F$6:$F$21 like range_name

And use:


=ISNUMBER(MATCH(A1,range_name,0))