Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - Please Help!!! | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |