Is it possible to create a drop down list in multiple columns and then after you enter a name for example, to be able to sort those names in the column? I have been trying to do this and have not been able to make it work in multiple rowns in a column.

I would appreciate any advice or let me know if this is not possible. Or if there is a way to do something similar in another way that I have not thought of yet. Also, is it possible to create conditional formatting so you can assign each name in the list a color?

Thanks