You can use Conditional Formatting. In the CF dialog, change "Cell Value Is"
to "Formula Is", enter =ISERROR($A$1) and choose a white font.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Tony Sheffield" <Tony wrote in message
...
?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