View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carusso carusso is offline
external usenet poster
 
Posts: 19
Default Validation List that will not allow cell to be empty

Hi again all! ;-)

Is there a way to use the Data/Validation/List function to only allow users
to only enter Y or N BUT cannot be left empty?

Or is there a Custom formula that will do this?

thanks!
--
carusso