If you don;t want the number to truly disappear, you can do:

Default format of A1 as Black
Default Format of A2:A10 as White

in cell A1:

conditional formatting
formula is:
=isnumber(A1)
format font as white

In cells A2:A10
formula is:
=isnumber(A1)
format font as Black.


=
"JRD-CFW" wrote:

I would like to know whether there is a formula that does the following:

*when i number into A1 it displaces the number
*when i delete the number in A1 it displaces the sum of A2:A10

in other words, is the a formula that would underlie whatever value i enter
into A1 but then appear if i were to delete the value (but not the formula,
obviously) in A1

i thought i fought something that did that but i can't find it again.

Thanks.

JRD