I would like to limit the input into a cell (y or n), based on the value in
the cell above it, (also y or n). So if one cell contains "y", then the user
cannot input "y" into the other cell. I'm familiar with data validation,
just not sure of the proper syntax to use.

Thanks.

Assuming the cells are F1 and F2, and you are setting up F2, use DV with a
Custom type and a formula of

=AND(OR(F2="Y",F2="N"),F2<>F1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Gubawatts" <(E-Mail Removed)> wrote in message
news:BB1EC60F-B7C7-4BFD-BA8E-(E-Mail Removed)...
>I would like to limit the input into a cell (y or n), based on the value in
> the cell above it, (also y or n). So if one cell contains "y", then the
> user
> cannot input "y" into the other cell. I'm familiar with data validation,
> just not sure of the proper syntax to use.
>
> Thanks.

Thanks Bob.

"Bob Phillips" wrote:

> Assuming the cells are F1 and F2, and you are setting up F2, use DV with a
> Custom type and a formula of
>
> =AND(OR(F2="Y",F2="N"),F2<>F1)
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "Gubawatts" <(E-Mail Removed)> wrote in message
> news:BB1EC60F-B7C7-4BFD-BA8E-(E-Mail Removed)...
> >I would like to limit the input into a cell (y or n), based on the value in
> > the cell above it, (also y or n). So if one cell contains "y", then the
> > user
> > cannot input "y" into the other cell. I'm familiar with data validation,
> > just not sure of the proper syntax to use.
> >
> > Thanks.
>
>
>