Excel for mac yes no drop down3/28/2023 Select the table without header row, and click Home > Conditional Formatting > New Rule. Please go ahead to add color for the drop down list.ģ. Now you have added a YES or NO drop down list in the selected list. In the Data Validation dialog, under the Settings tab, please select List from the Allow drop down list, type Yes,No in the Source box, and click the OK button. Select the list you will fill with the YES or NO drop down list, and click Data > Data Validation > Data Validation. If you want to create a YES or NO drop down list with color in Excel, please do as follows:ġ.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |