how do you add a drop down menu in excel 2016

Under the Format only cells with section, choose Specific Text from the first drop-down list and containing from the second drop-down list. Then you can see the New Formatting Rule dialog box, click the Format only cells that contain option under the Select a Rule Type section. Mark your drop-down cells, which in this case are in column A, and go to Home > Conditional Formatting then select New Rule. A Color-coded Drop-Down List with Conditional Formatting Now, we can add a color to the drop-down list.

Now, we can see the Drop-Down list below.

Now select the Source option and click OK. To see a screenshot, select Data > Data Validation > Data Validation.Īdditionally, in the Data Validation dialogue box, click the Settings tab and select List from the Allow drop down list. In this scenario, I positioned the drop-down list in the range A2:A6, as shown in the screenshot − Make a list of data and choose a range into which to place the drop-down list values. Let’s understand step by step with an example. Learn how to provide visual clues by adding a new list and validation control, followed by conditional format rules.įor example, I have created a drop-down list of city names when I select Hyderabad, I want the cell to be colored Yellow automatically, and when I select Chicago, I want the cell to be colored Blue, as shown in the screenshot below. We can add conditional formatting rules to the cell containing the drop-down list.

Color can be a powerful element in an Excel drop down list, and it's easier to incorporate than you may think.

How do you add a drop down menu in excel 2016