Jason Morin wrote:
Building off of Lady Layla's suggestion, assume we're
working with A1 and A2.

1. Click on A2.
2. Go to Data Validation.
3. Under "Allow", click "Custom". In the box below put:
=$A$1<""
4. Click on the "Error Alert" tab and put in an Error
message such as "Sorry, you must enter a value in A1
first."

Validation is a nice feature but can be easy overridden
by devious users. For example, you can copy and paste
over the Validation cell and erase the set-up. To learn
more about Validation in general, check out:

http://www.contextures.com/xlDataVal01.html

HTH
Jason
Atlanta, GA




-----Original Message-----
I would like to make a cell unwritable (i.e. a user
cannot input any data into it) until spefic line of text
is entered into the cell above it, is this possible in
Excek, and is fo how.

Many Thanks

Nick
.


I think the OP means that they want the cell to be locked until the text
is input - data validation won't LOCK a cell, will it?

--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!