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

[Guest]

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]

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