I am making a spreadsheet with a bunch of variables I want to change and some formulas that use those variables. I want to use conditional formatting (probably?) to color any cells which are "standing alone" or not affecting any other cells or not referred to in any other cells. Basically, I know the variables I need to include to make the calculations I want to make for this particular spreadsheet, but I don't yet know how each of those variables factors into the calculations I want to make. And I want to tackle the problem of how to incorporate those variables one by one. So I want to color the cells that represent "unused" variables so I can work my way through each variable and figure out how it needs to be used in the calculation.
Here's an overly simplistic and perhaps quite odd example:
- Bunnies I have now: 4
- Time horizon (in years): 5
- Bunnies I want to have in time horizon: 20
- Bunnies I need to acquire per year: X
Let's just say I have X as a formula properly set up to use the "Bunnies I have now" and "Bunnies I want to have" factored in, but I'm not sure how to factor in the time horizon just yet, so I want to color the time horizon cells in order to remember that I need to factor them in. This example has three variables and one calculation, but pretend I have 20 variables (which are consequently harder to track).
Does anyone know how to do this? How do you color a cell if it is not referred to in any other cells? Thanks in advance.
Here is the history of the searching I did before asking this question (per request from commenter):