The preset value could be entered as a formula which would result in an
"empty" cell if the other cell has a value..........

In C1 put =IF(LEN(D1)0,"","PresetValueHere")

Vaya con Dios,
Chuck, CABGx3



"pattyh" wrote:

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?