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.
|