View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
THFish THFish is offline
external usenet poster
 
Posts: 11
Default Conditional formatting

I am putting together a spread sheet with many formulas that track employee
performance. Not all formulas have values. Is there a way to Hide the formula
in a cell when there is not data for it to calculate?

Currently what is showing is "#DIV/0!". I would like to be able to print the
spread sheet out at any given time for a presentation and not have to read
arount the display that I am recieving when there is no data to calculate.

thank you