I would like one cell in my worksheet to display a specific text based upon the users pull down choices in anothe cell. There is the potential for 100 cells to contain the required input data.

Example:

If cell A1 contains Red I would like B1 to show Red
If cell A1 contains Red and A2 contains White I would like B1 to show White
If cell A1, contains Red, A2 contains White and A3 contains Blue I would like B1 to Show Blue.

Thanks for the help!