I don't think you can do it using data validation on one cell.

You could split it up into two parts or use somethink like the selection_change event and code behind that.