Drop-down list with functions?

**Elegidos** · 10-11-2009, 03:38 PM

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)

**whallgren** · 10-11-2009, 04:36 PM

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

**Elegidos** · 10-11-2009, 04:59 PM

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?

**Elegidos** · 10-15-2009, 04:46 PM

Does anyone have an answer

, hope someone can help me. Thanks

**jj72uk** · 10-15-2009, 05:41 PM

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

**JBeaucaire** · 10-15-2009, 06:33 PM

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.

**Elegidos** · 10-16-2009, 05:30 AM

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

**JBeaucaire** · 10-16-2009, 11:46 AM

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.