Data Validation

[Ben]

Hi,

1. Frank Kabel suggested using the following formula in
an earlier thread.

=A1<>""

I was tryng to use this so that if A1 has not had
anything entered into it, than you cannot enter anything
into A2 however it only works if I go into A1 and type
="". What am I doing wrong or what do I need to do so
that it works without having to type the ="" into every
cell.

2. I already have a list validation in this cell how
would I combine the both validations.

Ben

 

[Peo Sjoblom]

In the data>validation, uncheck ignore blank

 

[Guest]

Thanks!

How do I combine the blank cell [a1=<>""] Validation with
a List Validation?

Ben