is it possible to re-size or format list items in dropdown box?

i have created several drop-down lists using the data/validate function in
Excel, but the font / size of the list items in the drop-down list are too
small to read...

For a data validation dropdown list, you can't change the font size.
There are a couple of workarounds here:

http://www.contextures.com/xlDataVal08.html#Font

Or, there's a sample file here that provides a combobox from which you
can select one of the values from the data validation list. In the
combobox, you can change the font size:

http://www.contextures.com/excelfiles.html

jc wrote:
> i have created several drop-down lists using the data/validate function in
> Excel, but the font / size of the list items in the drop-down list are too
> small to read...


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html