+ Reply to Thread
Results 1 to 2 of 2

Drop Down Menu, adding Colour Font

Hybrid View

  1. #1
    Registered User
    Join Date
    01-26-2013
    Location
    Harare,Zimbabwe
    MS-Off Ver
    Excel 2010
    Posts
    46

    Drop Down Menu, adding Colour Font

    I am using Excel 2013

    I have done a costing work sheet.

    I have added a drop down menu of all the products.

    I have labeled the sections with a red heading so when I am looking for product using the drop down menu the items are in there categories.

    When I use the drop down menu, the products are listed as is the heading for the goods, However they are not shown in the Red I entered them. I would like the color of the heading to show if possible it makes finding the section easier.

    Any assistance will be greatly appreciated.

  2. #2
    Valued Forum Contributor
    Join Date
    01-08-2011
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2007 to 2016
    Posts
    456

    Re: Drop Down Menu, adding Colour Font

    Assuming you are using Data Validation for your drop down list, I don't believe it's possible to format the text in the drop down box in any way. Even if your source list has formatting, the drop down list ignores this and just shows plain text.
    Excel is a constant learning process and it's great to help each other. If any of us have helped you today, a click on the "reputation" star on the left is appreciated.

+ 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. Drop down menu/ filter by colour
    By ljw89 in forum Excel General
    Replies: 1
    Last Post: 06-11-2013, 08:05 AM
  2. Multiple Fill Color & Font Colour icons on menu bar
    By robertguy in forum Excel General
    Replies: 3
    Last Post: 02-05-2008, 10:46 AM
  3. Change font colour in drop down box
    By bobbych in forum Excel General
    Replies: 2
    Last Post: 05-01-2007, 04:04 AM
  4. Drop down Menu - change of colour
    By bengaluru in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-27-2006, 04:26 PM
  5. How do I increase the font of my drop-down menu options?
    By heliu8 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-14-2005, 02:10 PM
  6. drop-down menu font size
    By Bob Clarke in forum Excel General
    Replies: 1
    Last Post: 09-28-2005, 06:05 PM
  7. [SOLVED] Drop down menu-colour of the text
    By MGC in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-10-2005, 09:06 AM
  8. How do you resize the font in a drop-down menu?
    By Tim Britton in forum Excel General
    Replies: 2
    Last Post: 02-21-2005, 07:06 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