Preventing data input until a particular cell is used

[R]

Hi all,

Apologies if I have missed the obvious, but I need to prevent further data
input in a simple spreadsheet until a particular cell is completed.

There is a cell named "Week Ending" which needs the date for the next week
ending (Usually a Sunday) completed in the adjacent clear cell.
The person entering data into other cells *always* forgets to enter the date
in that cell and just gets on with sorting out a rota for employees, prints
the sheet, and then notices the date is wrong so has to do it all again or
pen it in.

How do I prevent them entering other data until the date is entered into
that cell?

Excel in Office 2007 if it matters...

 

[Susan]

a simple data validation formula should work
choose custom & enter in the formula area:

isblank(A1)

and in the error alert area, type PLEASE FILL IN CELL A1.

then they can't do anything until A1 is filled in.
hope it gives you an idea

susan

 

[R]

a simple data validation formula should work
choose custom & enter in the formula area:

isblank(A1)

and in the error alert area, type PLEASE FILL IN CELL A1.

then they can't do anything until A1 is filled in.
hope it gives you an idea

susan

Hi all,

Apologies if I have missed the obvious, but I need to prevent further data
input in a simple spreadsheet until a particular cell is completed.

There is a cell named "Week Ending" which needs the date for the next week
ending (Usually a Sunday) completed in the adjacent clear cell.
The person entering data into other cells *always* forgets to enter the
date
in that cell and just gets on with sorting out a rota for employees,
prints
the sheet, and then notices the date is wrong so has to do it all again or
pen it in.

How do I prevent them entering other data until the date is entered into
that cell?

Excel in Office 2007 if it matters...

Hi Susan,

Nope...........still allows input in any other cell if ignoring the cell
(C2) and not entering anything in it.

 

[Susan]

you'd have to put the data validation in EVERY other cell (it can be
copied & paste special - validation) that you don't want info entered
into - may not be feasible for you.
sorry!
susan