This question already has an answer here:
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