Click Data > Data Validation > Data Validation, see screenshot:ģ.
In this case, I select range A2:A6 to put the drop-down list, see screenshot:Ģ. Create a list of data and select a range that you want to put the drop down list values into. Method B Color coded drop down list with a handy tool-Colored Drop-down Listįor finishing this task, we need to create a drop down list first, please do as following steps:ġ. Method A Color coded drop down list with Conditional Formatting Are there any good suggestions to solve this? For instance, I have created a drop-down list of the fruit names, when I select Apple, I need the cell is colored with red automatically, and when I choose Orange, the cell can be colored with orange as following screenshot shown. In Excel, create a drop-down list can help you a lot, and sometimes, you need to color coded the drop down list values depending on the corresponding selected. How to add color to drop down list in Excel?
