Hi Faraz,

Yo can't do it with a data validation drop-down. Either format the data
validation cell with distinctive background and border, or change to a forms
drop-down or a control.

Ed Ferrero
www.edferrero.com