Could someone tell me how I do this,
Basically I have a spreadsheet from my lectuer, with lots of formulas, now for me to understand it properly (its an answer to an exam question) I need it to highlight the linked cells when I click on a cell with a formula in it.
i.e I click on H4 cell, this forumla has C15 and D13 in it, I want it to highlight those two cells, so I know they are the ones involved.
Have had this on before, not sure how to put it back on though..
ps. Im not talking about the arrows that show you the formula links, as they are a pain.
any help much appreicated.
Basically I have a spreadsheet from my lectuer, with lots of formulas, now for me to understand it properly (its an answer to an exam question) I need it to highlight the linked cells when I click on a cell with a formula in it.
i.e I click on H4 cell, this forumla has C15 and D13 in it, I want it to highlight those two cells, so I know they are the ones involved.
Have had this on before, not sure how to put it back on though..
ps. Im not talking about the arrows that show you the formula links, as they are a pain.
any help much appreicated.