![]() ⏩ I selected the G4 cell which contains the color Green. ![]() ➤ Now, select the cell address from the sheet that contains the Specific Text. In Edit the Rule Description select the Format only cells with options. ⏩ I selected the rule Format only cells that contain. From there select any rule from Select a Rule Type. ➤ Open the Home tab > from Conditional Formatting > select New RuleĪ dialog box will pop up. To begin with, select the cell range where Data Validation is applied already. ➤ As the drop down list is created I will add color to the values of the drop down list by using Conditional Formatting. ➤ Hence, Data Validation is applied for the selected range. From validation criteria select the option you want to use in Allow. Open the Data tab > from Data Tools > select Data ValidationĪ dialog box will pop up. To begin with, select the cell or cell range to apply Data Validation Here, I will create the drop down list of the Available Colors. Manually Create Excel Drop Down List with Colorīy using the Excel Data Validation feature I will create the drop down list later I will use the Conditional Formatting feature to color the drop down list values. ![]() Create Excel Drop Down List with Color.xlsxĢ Ways to Use Excel Drop Down List with Color 1. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |