View Single Post
  #1   Report Post  
Andrew Lindsay via OfficeKB.com
 
Posts: n/a
Default Data Validation (in a range of cells)

I would like to use the data (menu) / validation to constrain the input to
a range of cells. I only want the user to be able to enter a date value OR
the phrase "TBD".

Is this possible using the validation tool?

If not, I'm open for suggestions on how to do this?

Thanks,
Andrew