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

marked as duplicate by Rubén, user0, serenesat, jonsca Jan 28 at 23:23

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


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.


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