How can the font in the Data Validation list be changed?

G

Guest

I have some single character wingdings that I have a named range defined for.
I am using the named range as my data validation range. I have formated the
cells where the data validation is defined but the selection list shows the
characters using the default font settings. I changed the
 
D

Debra Dalgleish

You can't change the font in a data validation dropdown. If you can use
programming, there are instructions here for adding a combobox from
which you can select one of the values from the data validation list. In
the combobox, you can change the font to Wingdings:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top