Thread
:
Conditional formatting
View Single Post
#
2
Posted to microsoft.public.excel.misc
Chip Pearson
external usenet poster
Posts: 7,247
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
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson