Try this

Cell A1 =IF(B1="",C1,B1)

What does this do?

Firstly, enter your data in cell C1, (you can set the ink attributes in col C to be the same as paper, so nothing shows up).

Then A1 will display the value in C1, but only if B1 is empty.

Hope this helps.

Mark