blocking blank cells until other cells are compiled

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,
 
F

Frank Kabel

Hi
you may use data validation:
- select the cells B2:Bnn
- goto 'Data - Validation'
- enter the formula:
=B1<>""
 
A

arciduca79

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!
 
F

Frank Kabel

Hi
in the data validation dialog choose 'Custom'. Enter the formula in the
appearing input box
 
M

Microsoft

Quick way is to protect all cells and use macro which tests date to
unprotect each time opened.
 
Top