+ Reply to Thread
Results 1 to 8 of 8

Drop-down list with functions?

  1. #1
    Registered User
    Join Date
    10-06-2009
    Location
    Spain
    MS-Off Ver
    Excel 2007
    Posts
    50

    Drop-down list with functions?

    Hi,

    Is it possible to have a drop-down list where there are several items to choose from have each item to do something.

    For example, choose one item, let's name it Function1 and if that Function1 is selected, it will automatically change a rows background color and font? Or even a cell?


    Thanks in advanced
    Elegidos (Spain)

  2. #2
    Registered User
    Join Date
    10-25-2008
    Location
    Mount Joy, PA
    MS-Off Ver
    2003
    Posts
    44

    Re: Drop-down list with functions?

    It would depend on how involved the results would be.

    To change the background color use conditional formatting.

    To change a cell you can use and IF statement

  3. #3
    Registered User
    Join Date
    10-06-2009
    Location
    Spain
    MS-Off Ver
    Excel 2007
    Posts
    50

    Re: Drop-down list with functions?

    With conditional formatting? Ok, with that I did a few things with.

    But let's say that I select an item from the drop-down list in row 15, how can I make that row 15 change background change color and font? Also that drop down menu is used all the way down from 1 column. That it will be used on several rows.


    Another question. Related with the drop-down list. Is it posible to select an item from the list and once selected it moves the text from cell a1 to a3?

  4. #4
    Registered User
    Join Date
    10-06-2009
    Location
    Spain
    MS-Off Ver
    Excel 2007
    Posts
    50

    Re: Drop-down list with functions?

    Does anyone have an answer , hope someone can help me. Thanks

  5. #5
    Valued Forum Contributor jj72uk's Avatar
    Join Date
    03-22-2008
    Location
    Essex, England
    MS-Off Ver
    Work - Office 2000, Home - Office 2007E
    Posts
    360

    Re: Drop-down list with functions?

    How are you wanting to select the item? Check box? Would it be a specific color/font that you want or will it vary?

  6. #6
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Drop-down list with functions?

    Elegidos, the answer to the question "Can I do XX?" and "Can I do YY?" is almost always "YES".

    Now, instead of asking in generalities, detail out exactly what you want to do. For instance:

    1) In column A a drop down has 3 choices
    First
    Second
    Third
    2) If First is chosen, I want the entire row from A:Z to color white font with black background
    If Second is chosen, I want the entire row from A:Z to color Blue font with yellow background
    If Third is chosen, I want the entire row from A:Z to color Black font with Red background

    3) If I make a choice in A1, I want B1 to change value too:
    First = Top
    Second = Middle
    Third = Bottom

    Etc.... you get the idea. If you explain your process exactly, or even better post up a sample workbook SHOWING the before/after goals, this will go much faster for you.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  7. #7
    Registered User
    Join Date
    10-06-2009
    Location
    Spain
    MS-Off Ver
    Excel 2007
    Posts
    50

    Re: Drop-down list with functions?

    OK, sorry for any misunderstand or bad explanation, my fault. Let me start again from the beginning.


    EXAMPLE 1:

    1) Column A with 1 link in each cell. (Column A with same amount of rows as column D)

    2) Column D with drop down list with 2 choices.

    - yes
    - no

    3) If yes is chosen I want the link (cell) from column A to move to column C.
    If no is chosen I want the link (cell) from column A to move to column B.


    Example 2:

    1) Column A with a drop down list with 1 choice.

    - Black

    2) If black is selected, I want that entire row to change the background and font to color Black

  8. #8
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Drop-down list with functions?

    Example 1)

    Sorry, I have no idea what a link cell is. Post up a sample workbook demonstrating this...show before and after.

    Example 2)
    Surely you don't mean "the entire row". I tried in my original post #6 to demonstrate an exact range of cells to change color. Your data goes through how many columns? If your data is 20 columns wide, then coloring 16,000 columns is pretty silly, yes?

    - Highlight the columns you DO want to color
    - Activate the conditional formatting function (I don't know where they've hidden that in Excel 2007, you'll have to find it.
    - The CF formula (rule?) you will use is:
    =$A1="black"
    ...and you will select the background and font color of your choice.

+ 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