![]() Select the cell or cells that contain your drop-down list and in the top menu select Format>Conditional formattingĢ. ![]() To do this, we will be adding conditional formatting to it.ġ. Now that you have created your drop-down list, we can begin to add color to it. You should now see a drop-down list in your cell with the options that you entered in step 4 In the text field next to Criteria, enter the values that you want users to select from your drop-down separated by a comma. I will choose List of items in this exampleĤ. Then navigate to the Criteria section and set it to either “List from a range” or “List of items”. Then from the drop-down select Data validationģ. Select the cell where you want the drop-down list to appear, and in the top menu select DataĢ. We will be using data validation to do this.ġ. Color a Drop-Down List Creating Your Drop-Down Listīefore we can add color, we have to actually create a drop-down list.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |