I have setup data validation on a cell to force the user to choose from a
drop down list of words.

How can I make the data validation function put up an error message if the
user picks one of the choices on the list and there happens to be no date
entered in another totally different cell under another column (this other
cell I'm referring to does not have any data validation setup for it)?

- Chet