Conditional formatting

T

Tony Sheffield

?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
 
C

Chip Pearson

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)
 
S

swordsman

go to format>conditional formatting>
Condition 1
Formula is :=ISERROR(A1)
click Format>Font>Color *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.
 
Top