Conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

?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
 
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)
 
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.
 
Back
Top