AELLC
Structural
- Mar 4, 2011
- 1,339
Is it possible to set it up so the cell color changes when I manually type a number into a cell that has a formula, i.e., deliberately replacing the formula with the desired number?
I like to provide a sort of "manual override" in my design workbooks, and wanted to see at a glance which cells had been overridden. Frequently the overridden cell has cell dependents, and that helps the way my workbooks function...but there are cases where is overlooked that I should restore to the original formula.
If this is not possible, then I will continue to use Formula Auditing, Show Formulas, but it would be great to do as described above.
Another way would be to set up the adjacent cell with the same formula but no dependents, to show me if the 2 cells display different values, but that is cumbersome in my congested workbooks.
I like to provide a sort of "manual override" in my design workbooks, and wanted to see at a glance which cells had been overridden. Frequently the overridden cell has cell dependents, and that helps the way my workbooks function...but there are cases where is overlooked that I should restore to the original formula.
If this is not possible, then I will continue to use Formula Auditing, Show Formulas, but it would be great to do as described above.
Another way would be to set up the adjacent cell with the same formula but no dependents, to show me if the 2 cells display different values, but that is cumbersome in my congested workbooks.
