View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLS JLS is offline
external usenet poster
 
Posts: 4
Default How do you create a list & data validation in same cell?

I have a range of 7 cells in a column. I want to be able to

a-allow only a "True" input (from a drop down list unless there is another
way to accomplish this)

b-if any of the other cells already contain "True", they can not duplicate
the entry in the other cells and display an error message that says they can
answer "True" only once in the range of cells.