I have a worksheet with pre-filled info, but if there is a variance to that
info placed in a different box, how do I get the pre-filled one to disappear.
The pre-filled one is protected.
Example:
C is prefilled and protected, D is the variance box, not protected, if D is
filled with a number, how do I get C to "hide" or disappear?