Data|validation doesn't allow you to do this.

In fact, no excel built-in control allows you to do this.

Ramesh wrote:

Need to create a drop down list using data validation.
Both value and the format/pattern of the cell needs to be considered.

Many thanks in advance

--

Dave Peterson