I know how to tell which cells are used in the formula of the selected
cell, but is there any way to tell if the selected cell is used in
other formulas?

One way:
Tools Formula auditing Trace dependents