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