View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default data validation fonts differ in drop down box

Short answer: You can't change font size/type/list length in data validation

See link for more info:
http://www.contextures.com/xlDataVal08.html#Font
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Doc77" wrote:

I am using Excel 2003. I have a group of cells with a data validation
"list". That list contains 3 options -- check mark, "X", and "box" -- in
Webdings. When you click the drop down box to make a selection the options
are in alpha-numeric characters (Arial font(?)) and not Webdings. So my
"check mark" becomes an "a" and my "X" becomes an "r".

How can I get the drop down box to display the same font as the one in the
list?

Both the drop down box cells and the "list" cells are formatted with the
Webdings font.

Thanks for your help.