Get more Excel tips How to add color to an Excel drop-down list If you’ve used data validation controls, you know how easy they are to add and how helpful they can be.

The second Excel drop down list will display the representatives in that region. To the right, you see labels and formats in preparation for creating the Excel drop down list.