Permission to fill in cell when another cell has a value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AA Arens - 02 Dec 2006 13:45 GMT

How to set that in a cell B1 it is allowed to fill in data only when
Cell A1 has any or has a certain value . I guessed via Data Validation,
but failed.

Bart
Excel 2003

Reply to this Message

Debra Dalgleish - 02 Dec 2006 15:31 GMT

Select cell B1, and choose Data>Validation
For Allow, choose Custom
In the Formula box, enter: =A1<>""
Remove the check mark from Ignore blank
Click OK

> How to set that in a cell B1 it is allowed to fill in data only when
> Cell A1 has any or has a certain value . I guessed via Data Validation,
> but failed.

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

AA Arens - 03 Dec 2006 01:49 GMT

What is the command when two cells should have contents before allowing
a third cell to be filled. With =(D7:E7<>"") I get allowance is one of
them has data.

Bart

> Select cell B1, and choose Data>Validation
> For Allow, choose Custom
[quoted text clipped - 8 lines]
> Debra Dalgleish
> Contextureshttp://www.contextures.com/tiptech.html

Reply to this Message

Dave Peterson - 03 Dec 2006 03:02 GMT

Try:

=AND(D7<>"",E7<>"")

or

=COUNTA(D7:E7)=2

> What is the command when two cells should have contents before allowing
> a third cell to be filled. With =(D7:E7<>"") I get allowance is one of
[quoted text clipped - 14 lines]
> > Debra Dalgleish
> > Contextureshttp://www.contextures.com/tiptech.html

Signature

Dave Peterson

Reply to this Message

AA Arens - 03 Dec 2006 03:13 GMT

Thanks, Dave. AND works

> Try:
>
[quoted text clipped - 26 lines]
>
> Dave Peterson

Reply to this Message

Rate this thread: