Data validation dependent on value in another cell.
 

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.

Data validation dependent on value in another cell.
 

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" wrote in message
...
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.

Data validation dependent on value in another cell.
 

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" wrote in message
...
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.