go to formatconditional formatting
Condition 1
Formula is :=ISERROR(A1)
click FormatFontColor *select white*

If the worksheet has to be printed, don't set-up using black and white,
since it will print the "#DIV/0!" error message.

Otherwise, place an If formula directly in the cell to hide error messages.


"Tony Sheffield" wrote:

?I have designed a spredsheet that frequently has a formula that requires
inputs from other cells. As all the cells are empty, all the formulae return
the "#DIV/0!" error message.
Is it possible to somehow format the cells so that if there isn't an actual
number then the cell is formatted to white text and therefore appears blank