![how to make a drop down list in excel with color how to make a drop down list in excel with color](https://www.exceltip.com/wp-content/uploads/2015/05/pasted-image-0-18.png)
- How to make a drop down list in excel with color how to#
- How to make a drop down list in excel with color free#
And also you can follow us on Twitter and Facebook. If you liked our blogs, share it with your friends on Facebook. You can create a dropdown list in google sheets using the same method. Repeat the process for all the options like Green and Blue and your list will be shown like in below snapshot.ĭrop down list and Conditional formatting tools are very useful in Excel 2016, to view your data in a particular format manner. Of course, creating dynamic dropdowns requires a bit more time and more complex formulas, but I believe this is a worthy investment because once set up, such drop-down menus are real.
How to make a drop down list in excel with color free#
To avoid having Excel show warnings when cells contain older dates, make sure to turn off the warnings and errors when setting up the data validation. The main advantage of a dynamic Excel dependent drop-down list is that you are free to edit the source lists and your drop-down boxes will get updated on the fly. This will allow you to select either a checkmark or the current date as shown in the image below. Select Specific Text option and select the cell for colour as in this case Red. Then, use data validation to create a drop-down list referencing those two cells. The cell width will determine the width of your list entries that are too long will be truncated with ellipses (.), so take this into consideration.
![how to make a drop down list in excel with color how to make a drop down list in excel with color](https://computeexpert.com/english-blog/excel-tips-and-trick/screenshot/dropdown/color-excel-drop-down-list-9.png)
Select New rule from the list and a dialog box will appear. A couple things to note: the list must be in a single column or row, make sure there are no blank cells, and structure the items in the order you wish to appear in the drop-down list. Select the option List in Allow and select the source list in Source option and click OK.Ī dropdown list will be created on the cell. We need that the user has to select from this list.Ĭlick Data > Data Validation option in Excel 2016ĭata Validation dialog box appears as shown above. Change the second drop down to containing. In the lower section, change the first drop down setting (Cell Value) to Specific Text. Here is a list of three colours Red, Green and Blue. In the top pane, select the Format Only Cells That Contain option.
How to make a drop down list in excel with color how to#
We will be using Conditional Formatting and Data Validation options.įirst, let’s understand how to make a dropdown list in Excel with an example here Select the cell that contains the drop down list, and then in the Ribbon, select Home > Styles >. In this article, we will learn how to create a Dropdown list with color in Microsoft Excel.ĭrop down list limits the user to choose a value from the list provided instead of adding values in sheet. Amending the Background Color With Conditional Formatting 1.