Finding cells used in a Formula across multiple Sheets

[rollorcosterdude]

I am wondering if there is anyway to see which cells have already been selected for a formula with the cells on multiple sheets.

Is there a way to show the selected cells in a formula like when they are on the same sheet and it outlines the selected cells in different colors? I really like this about the formulas on a single sheet.

For instance is there a way to show the cells that are in this formula?
='11.14-11.20'!B38+'11.28-12.4'!B34+'12.12-12.18'!B39

Maybe even a way so that when you select a cell for the formula the cell changes color?

It is hard to see which cells have already been selected for a formula on a different sheet so you don't select the same cell twice.

Any Help would be greatly appreciated.

Thank you

 

[Derek Brown]

Hello and welcome to The Board.
Have a look at the following post:
http://www.mrexcel.com/forum/genera...questions/727053-better-trace-precedents.html
It also mentions Spreadsheet Detective but, in my opinion, that is not for the faint-hearted because it takes some effort to learn how to use it.
Also have a look at:
https://www.youtube.com/watch?v=4b72t_IjTW4
https://www.youtube.com/watch?v=30ueuvf5Aj4
https://www.youtube.com/watch?v=J49ornVCKYQ