how do you add a drop down menu in excel 2016

To add a conditional rule that changes the font color to red when the selected list value is red, follow these steps. With the new list in place, you’re ready to add the conditional formatting.įigure A Add a new list of colors in Excel. Using the instructions from a previous Excel drop down list article, create a drop down list in E4 using the color list as the source. To begin, add a new sheet and then add a new list with the text items red, blue, green, and yellow ( Figure A). You can work with your own data or download the demonstration. Learn how to add a new list and validation control, and then add the conditional format rules to include visual cues. Windows PowerToys 0.62.0 adds three new utilities to the Windows power user toolkitĭefend your network with Microsoft outside-in security servicesĬolor can be a powerful element in an Excel drop down list, and it’s easier to add than you might think-you simply add conditional formatting rules to the cell containing the drop down list. Image: Kerkez, Getty Images/iStockphoto Must-read Windows coverage For more info, visit our Terms of Use page. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. This tutorial shows the steps for adding color to a drop down list in Microsoft Excel. How to add color to a drop down list in Excel

How do you add a drop down menu in excel 2016