Permission to fill in cell when another cell has a value

[AA Arens]

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

 

[Debra Dalgleish]

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

 

[AA Arens]

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

 

[Dave Peterson]

Try:

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

or

=COUNTA(D7:E7)=2

 

[AA Arens]

Thanks, Dave. AND works

Try:

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

or

=COUNTA(D7:E7)=2



AAArenswrote:


Dave Peterson