Don't know what kind of question this is?

L

LiveUser

In cell B2 I have a drop down box. For example, my drop down box is orange,
grape, banana, watermelon.

When I choose Grape from cell B2 I want Cell A1 to populate with Purple,
basically whatever color goes with whatever fruit.

Preferably, I would also like cells C2:F2 to create a border around the
cells after something has been selected in A2.

I also want, after choosing grape in Cell B2, not only to populate cell A1,
but also go down one row to start the entire process over again.

So, now in B3 I can choose another fruit and the process continues.


Is this possible?
and how?

Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create tabs named after a group of cells? 3
Drop Down Box Values - Excel 2003 0
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Data Validation and drop-down list using IF, AND and what else? 8
tabulate output data from different combination of input. 0
Linking Merged Cells in Different Workbooks 7
Prevent duplicate entries within a range of cells from a drop-down 3
Please help. This is way too tough for me. 2

Top