blocking blank cells until other cells are compiled

  • Thread starter Thread starter arciduca79
  • Start date Start date
A

arciduca79

Hello everyone.

I'm working on several columns. Each column corresponds to a certai
date. I would like the fields under the date cell to be "available
only if the date cell is filled. How do I do this?

Say in cell "A1" I have today's date and in "B1" tomorrow's (and s
on). In cell "A2" I want to put the number of dollars I have spen
during lunch and in cell "B2" I will want to do the same, but onl
tomorrow of course.
I would like to "compile" the whole month in terms of columns but
would like NOT to be able to write in the "B2" cell until I have fille
the "B1" cell.
Is there any way to do this?

Thanks again,
 
Hi
you may use data validation:
- select the cells B2:Bnn
- goto 'Data - Validation'
- enter the formula:
=B1<>""
 
thank you frank - but I don't seem to be able to find an option where t
put the formula you said I should enter!

It does look like that's the answer to me though!
 
Hi
in the data validation dialog choose 'Custom'. Enter the formula in the
appearing input box
 
Quick way is to protect all cells and use macro which tests date to
unprotect each time opened.
 
Back
Top