+ Reply to Thread
Results 1 to 4 of 4

change font for validation data list

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    07-20-2007
    MS-Off Ver
    2016, 365
    Posts
    127

    change font for validation data list

    Hi All.
    I created validation list using Validation option in Data menu. Now I would like to change font for that list. If it possible how to do it?
    Thanks.
    Last edited by eugz; 10-07-2008 at 12:23 PM.

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191
    You can change the font for the cell that validation is applied to and it will appear with that font when selected. As for the dropdown list itself, I don't know of a way to change it.

  3. #3
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111
    Hello peoples,

    I have not try this yet, but give it ago.


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


    @ darkyam: Good to see your back !

    Cheers
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

  4. #4
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191
    Thanks, Ratcat. Good to be back.
    Nice find on the solution; I had seen similar questions on this and other forums before that even some of the greats had said there is no way to do it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 09-29-2008, 11:11 AM
  2. Drop Down List Not Picking Up All Column Data
    By short9974 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-12-2008, 02:50 PM
  3. Data Validation list
    By newtoVBA in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-20-2007, 07:03 PM
  4. Dynamically change list in a userform
    By Cumberland in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-20-2007, 03:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1