-1

In a google sheet I have some values that are used in formulas in other cells (until now, nothing unusual...).

I would like these cells to have a special color to be aware that if I modifiy them, other cells will be modified as well. Is there a function to test if a cell's value is used elsewhere?

I am looking for a simple built-in way to do this, without macros, and I just need to know wether the cell is used elsewhere or not, not by whom, or neither what it does.

Thanks for your help

0

At this time there is no built-in way to find precedent/dependent cells, the only way is by using an add-on or script.

Related

Not the answer you're looking for? Browse other questions tagged or ask your own question.