I was searching regarding highlighting cells from other sheet (in edit mode) but could not find any solution to it. (Just like we can do when editing a formula).
Hope i make myself Clear.
For example A3= =Sheet2!F9+Sheet2!F11
then somehow when i go top the other sheet i can see which cells was my formula linked to.
PS: I do not want to trace predecessors or something like this because i want a visual cue to see the cells. Makes my job easier to review the sheet... Any ways out/???
Any kewl addins which can do the task???
Hope i make myself Clear.
For example A3= =Sheet2!F9+Sheet2!F11
then somehow when i go top the other sheet i can see which cells was my formula linked to.
PS: I do not want to trace predecessors or something like this because i want a visual cue to see the cells. Makes my job easier to review the sheet... Any ways out/???
Any kewl addins which can do the task???