LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to Identify Col Data-Pairs that Differ by 2*pi monir Excel Worksheet Functions 2 November 22nd 07 03:47 AM
Data Validation - Drop Down Box L2Lafferty Excel Worksheet Functions 3 December 28th 06 07:25 PM
Can the contents of a drop down box differ from what's entered? ForkHandles Excel Worksheet Functions 1 October 31st 06 05:35 PM
Data Validation - Drop Down John Excel Worksheet Functions 3 April 25th 06 03:50 AM
How can I lengthen the drop down Fonts list to show more fonts at Moser D Excel Discussion (Misc queries) 1 February 5th 06 03:24 PM


All times are GMT +1. The time now is 04:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"