Similarly, you may use conditional formatting to assign colors to items in a drop-down list. How to create a drop-down list in Excel To create a drop-down list in Excel, follow these steps- ...