View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ALEX ALEX is offline
external usenet poster
 
Posts: 493
Default Data Validation Query

In my current worksheet, I have a setup for each individual person, and with
2 of my fields I have in list boxes, Title (Mr,Mrs,Miss,Ms) and Gender
(Male,Female). I would like to be able to put a condition in place that would
show an error message if Female was entered into the Gender field when Mr was
selected, and if Mrs,Miss,Ms was selected when Male was chosen in the gender
field.

Is there anyway of doing this, considering they are both list boxes?