Conditional formatting
 

?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

Conditional formatting
 

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

Conditional formatting
 

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