View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Farmer Ted Farmer Ted is offline
external usenet poster
 
Posts: 12
Default Blank Cells (or Blanking Cells)

I have made an excel spreadsheet and it is looking real nice. However, I was
wondering, How do I stp a formula from appearing if I do not want it to
appear unless there is a contents in the cells that will generate it. I have
two columns that have formulas in them but I do not want the formula (or
data) to show unless there is data in that row. The two formulas are = Today
() - I only want this to show when something is place in that row. As it
is it goes all the way down the page. How do I fix this.

The other formula is a calculation of that box vs the date input in a prior
Cell (i.e. what the difference in those days are [ 45 day difference, 20 day
difference etc] Any help with this. . .or where I can look?