conditional data input into a cell

[Rekoop]

Hello,

I am having difficulty putting a condition on a cell(s)
that data cannot be entered unless data has been entered
in another specified cell first.

i.e. user is unable to enter data into A2 unless data has
been previously entered in A1.

Thanks

 

[J.E. McGimpsey]

One way:

Select A2. Choose Data/Validation:

Allow: Custom

Formula is: =LEN(TRIM(A1))<>0

 

[Peo Sjoblom]

I can't get that to work (excel 2003), this works
for me

=LEN(TRIM(OFFSET($A$2,-1,,)))<>0

 

[Gord Dibben]

Peo/John

John's formula won't work in 2002 either.

Peo's is OK

Gord Dibben XL2002

 

[Debra Dalgleish]

J.E.'s formula works if you remove the check mark from 'Ignore blank'

 

[Gord Dibben]

Thanks Debra and apologies John.

Slap on forehead!

Gord

 

[Peo Sjoblom]

Well, John never told us to uncheck that!? <bg>

--

Regards,

Peo Sjoblom

J.E.'s formula works if you remove the check mark from 'Ignore blank'

Peo/John

John's formula won't work in 2002 either.

Peo's is OK

Gord Dibben XL2002

 

[Paul B]

Just to let everybody know J.E.'s formula works in 2000 WITH ignore blanks
checked

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

Well, John never told us to uncheck that!? <bg>

--

Regards,

Peo Sjoblom

J.E.'s formula works if you remove the check mark from 'Ignore blank'

 

[J.E. McGimpsey]

Sorry, guys - i guess I thought that would be obvious...

(or perhaps I just forgot to include that step...)

 

[Gord Dibben]

John

"Obvious" to us older persons is a 2x4 upside the ear.<g>

Gord