I am trying to find out what cells in a column are picked up in a formula elsewhere (in a different tab) and what wells in the column are not. Is there a way to use conditional formatting to color code cells that are picked up by a formula and what cells are not?
Thank you.
Thank you.