View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gubawatts Gubawatts is offline
external usenet poster
 
Posts: 3
Default 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.