+ Reply to Thread
Results 1 to 16 of 16

Using color coding in a drop down menu.

  1. #1
    Registered User
    Join Date
    02-11-2008
    Posts
    3

    Exclamation Using color coding in a drop down menu.

    Ok, So I figured out how to create a drop down menu in excel. I would like to color code the menu options. Here is my menu list: Green, Red, Yellow, Blue. I have them in the drop down menu and I would like to put their associated name with the appropriate color background rather than just use white cell with black letters. Green would have a green cell color, Red would have a red cell color, and so on and so forth. Any suggestions?


    Ok when you choose blue from the list then it would show the word BLUE and it's color. Is that possible?

    Mia
    Last edited by Glossgurl7; 02-12-2008 at 01:02 PM.

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good afternoon Glossgurl7

    Quote Originally Posted by Glossgurl7
    would like to color code the menu options.
    Unfortunately, you can't. You can have the background any colour you please, and the same with the foreground, but you can't mix the colours I'm afraid.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Registered User
    Join Date
    02-11-2008
    Posts
    3

    Re:

    Ok when you choose blue from the list then it would show the word BLUE and it's color. Is that possible?

  4. #4
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Hi Glossgurl7

    When you say a drop down menu, what exactly are you referring to?
    In brief, how did you create it - just so we are talking about the same thing ...

    DominicB

  5. #5
    Registered User
    Join Date
    02-11-2008
    Posts
    3

    Re:

    Ok, I made a list:

    List (Color needed)

    Extreme (Red)
    High (Orange)
    Moderate (Green)
    Low (Yellow)

    Then I went to data validation and made the list into a drop down menu.

    What I would like to do Is that I when I choose option Extreme from the drop menu I created I would like it to have a Red color either text or cell color. But I would like the color to change depending on option I pick from the list.

  6. #6
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Hi Glossgurl7

    OK, thanks for that.

    No you can't have colour in a data validation listing. There are two other ways of creating dropdown lists in your spreadsheet, using the Forms toolbar (no colours allowed - standard only), and using the Control Toolbox (colours allowed, but only a single colour for the background / foreground - you can't colour code each line).

    HTH

    DominicB

  7. #7
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Using the ComboBox from the Controls ToolBox you can change the colour based on the Combo' value, or ListIndex.
    Attached Files Attached Files
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  8. #8
    Registered User
    Join Date
    12-04-2009
    Location
    Stockholm Sweden
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Using color coding in a drop down menu.

    Hi I am trying to use the combobox to fill a cell with both the figure and color. The problem is that I am totally new to excel.

  9. #9
    Registered User
    Join Date
    10-28-2010
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Using color coding in a drop down menu.

    1) Create your drop down list in any cell using Data Validation with fields. e.g, Low, Medium,High
    2) Highlight the drop down cell.
    3) Select Conditional Formatting
    4) Select Highlight cell rules, more rules
    5) Select Format only cells that contain
    6) Change the value in the format only cells with: to Specific Text
    7) Enter the text field . e.g. Low
    8) Select Format tab.
    9) Select the Fill tab and select your colour e.g. Green.
    10) Click Ok twice.
    11) Repeat steps 2 to 10 for each other drop down selection e,g, Medium for amber, and High for Red.
    12) Test the colours work if not you've done somethign wrong above.
    13)After all this just cut and paste the finished drop down to everywhere you want to use it.
    or you can check details on
    http://techrepublic.com.com/5208-623...ontent;leftCol

  10. #10
    Registered User
    Join Date
    11-15-2011
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Using color coding in a drop down menu.

    This was very helpful, thanks. It didn't work the first time as you need to select all the cells in the drop down box range, not just the one that contains the drop down arrow.

  11. #11
    Registered User
    Join Date
    11-28-2012
    Location
    Gilbert, AZ
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Using color coding in a drop down menu.

    Use conditional formatting to color code the data.

    Nichole

  12. #12
    Registered User
    Join Date
    07-30-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Cool Re: Using color coding in a drop down menu.

    Thanks helped me alot!

    EDIT: mamitkapoor

  13. #13
    Registered User
    Join Date
    09-25-2013
    Location
    Dallas Texas
    MS-Off Ver
    Excel 2007
    Posts
    1

    Cool Re: Using color coding in a drop down menu.

    thanks Mamitkapoor!!

  14. #14
    Registered User
    Join Date
    04-20-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    77

    Re: Using color coding in a drop down menu.

    The way to use of color coding in drop down menu is really awesome and useful for us Thanks everyone and Excel forum too.

  15. #15
    Registered User
    Join Date
    07-23-2015
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    1

    Re: Using color coding in a drop down menu.

    Help please -I have done all this a few times now and just cant get the colours working!! Not sure what I am doing wrong.

  16. #16
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Using color coding in a drop down menu.

    robcol,
    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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