keeping dates in cells hidden

R

ramona

We have Office 2003 and I have users of every level so i need to keep all
parts of my spreadsheet at a beginners level. Most of the spreadsheet will
be locked but I have a row which will be for dates. They will only have to
key in the first date and then I've set a very simple formula to autofill.
What I would like assistance with is keeping those cells blank until the
first cell has been filled. I have read through almost all the threads here
but can't find anything. I know it's there but I'm not finding it. Thanks
so much.
 
O

Otto Moehrbach

Ramona
Do you have formulas in those cells? If so, do you want those cells to
display a blank cell until that first cell is filled by the user? It would
help if you posted your formulas, but the basic format of the formula to do
what you want is:
=IF(A1="","",your formula here)
This says if A1 (replace with your cell address) is blank, display a blank
cell. If A1 is NOT blank, do your formula. HTH Otto
 
R

ramona

Thank you. This is what I was looking for. I just had my simple formula
incorrect. If I had written my formula in this thread I probably wouldn't
have needed this. So thanks for your patience and assistance.
 
Top