Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    May 2008
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am using Excel 2003 version.

    Is it possible to bold a list in my drop down list? For example, if my drop down content the following: Jan, Feb, Mar, Apr, May,.... And I want May to be bolded. Please help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    That is not possible, at least not without using complicated Windows API code.

  3. #3
    Star Lounger
    Join Date
    Feb 2009
    Location
    Kings Park, Victoria, Australia
    Posts
    90
    Thanks
    15
    Thanked 5 Times in 5 Posts
    [quote name='HansV' post='787846' date='07-Aug-2009 10:48']That is not possible, at least not without using complicated Windows API code.[/quote]


    I have just tried this by typing a lookup list starting at Cell A1, then in C2 I set data validation to look at this list. Once the drop down was created I then set conditional formatting to bold the required choice.

    See attached.
    Attached Images Attached Images
    Attached Files Attached Files
    Maria
    Simmo7
    Victoria, Australia

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    I think the idea was to have it appear bold in the dropdown list, not when selected in the cell (that's what Hans meant about the API code being required)
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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