View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tony Sheffield Tony Sheffield is offline
external usenet poster
 
Posts: 1
Default 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