Excel drop down list with color
Do you want to add colour to a drop-down list in Excel? It’s very easy, create a drop-down list and add conditional formatting rules to the cell. Color can be a powerful element in an Excel drop down list, on the upcoming lines we will see how to add a new list and validation control, and then add the conditional format rules to include visual cues. How to create a drop down list in Excel?Add a new sheet and then add a new list with the text items red, blue, green, and yellow Create a drop down list in E4 using the color list as the source To create a drop-down list in E4:
How to add color to the drop down list?To add a conditional rule that changes the font color to red when the selected list value is red, follow these steps.
If you selected the other three list items, the font will still black. To change this, create a new rule for the other three using the same method. Related Articles
One way to streamline data entry is to create custom lists in Excel and use them to create drop-down lists in specified cells. When you use the program's Data Validation tool, along with its Conditional Formatting feature, you can make a drop-down list that is color-coded, enabling you to determine data at a glance. You can customize the list colors to coordinate with your logo, topic or other data.
In this article, we will learn how to create a Dropdown list with color in Microsoft Excel. We will be using Conditional Formatting and Data Validation options. Here is a list of three colours Red, Green and Blue. We need that the user has to select from this list. Click Data > Data Validation option in Excel 2016 Data Validation dialog box appears as shown above. Select the option List in Allow and select the source list in Source option and click OK. A dropdown list will be created on the cell. Now click Home > Conditional formatting. Select New rule from the list and a dialog box will appear. Select Specific Text option and select the cell for colour as in this case Red. Select Format > Fill option. Select the Red colour and click OK. Repeat the process for all the options like Green and Blue and your list will be shown like in below snapshot. Drop down list and Conditional formatting tools are very useful in Excel 2016, to view your data in a particular format manner. You can create a dropdown list in google sheets using the same method. If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook. Check out more related articles: How to edit a drop down list in Excel? Popular Articles: 50 Excel Shortcut to Increase Your Productivity How to use the VLOOKUP Function in Excel How to use the COUNTIF function in Excel 2016 How to use the SUMIF Function in Excel |