conditional data input into a cell

  • Thread starter Thread starter Rekoop
  • Start date Start date
R

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
 
One way:

Select A2. Choose Data/Validation:

Allow: Custom

Formula is: =LEN(TRIM(A1))<>0
 
I can't get that to work (excel 2003), this works
for me

=LEN(TRIM(OFFSET($A$2,-1,,)))<>0
 
Well, John never told us to uncheck that!? <bg>

--

Regards,

Peo Sjoblom


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

Gord said:
Peo/John

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

Peo's is OK

Gord Dibben XL2002
Click to expand...
Click to expand...
 
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 **
Peo Sjoblom said:
Well, John never told us to uncheck that!? <bg>

--

Regards,

Peo Sjoblom


Debra Dalgleish said:
J.E.'s formula works if you remove the check mark from 'Ignore blank'
Click to expand...
Click to expand...
 
Sorry, guys - i guess I thought that would be obvious...

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