![How to Insert Color Coded DropDown List in Microsoft Excel](https://nexacu.com.au/media/old-blog/2019-01-5.png?width=1032&height=588&mode=max)
Step 2 now click the new.
How to create drop down list in excel and color code. Inserting drop down list 3. So , let’s enter the values in the range a1 to a3 as shown. You can add or delete items from your drop.
Web simply click the arrow and select an option. Select one or more cells where we want the dropdown list to appear.