Data Validation

[stak]

Hi Leo

Sorry about all this confusion. If the user enters Y into
A1 first, then they cannot enter Y into any of the other
cells.

However, if the user enters Y into either A2, A3, A4 or A5
first, then they cannot enter Y into A1. It is basically
A1 or A2:A5.

Is this any clearer.

Thanking you in advance.
Regards, Sue

######################

Hi Sue

I don't think, I got an answer to my question.

If e.g. X is entered in A1 (A2:A5 empty),
and then Y is entered in e.g. A4, what will
happen then? I mean Y in A4 should prevent
anything from being entered in A1, but A1
allready has a value!? Are you looking for
a solution, which in this situation will blank A1?

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"[email protected]"

Hi Leo

Basically, if I enter Y in A1, then I want to make sure
that I cannot enter Y in any of the other cells. However,
if I enter Y in any one of the other 4 cells (A2:A5)or all
of them, then I want to make sure that I cannot enter
anything into cell A1.

I hope this makes sense. Thanking you in advanced.
Sue

..