Assign Colours to Items in the Drop-down List
You can assign different colours to the options in the drop-down as follows:
Step 1: Click the Pen Icon
Select the drop-down by simply clicking on it and then select the pen icon present at the bottom.
Step 2: Click the Colour Drop-Down
Click on the drop-down present to the right of the grey-coloured circle. This will open a panel of colours.
Step 3: Select the Colour
Select the desired colour from the panel. You can preview how the drop-down will look from the bottom of the panel.
Repeat the same for all options and close the side pane when you are done.
Output:
How to Add Dropdown List in Google Sheets
A drop-down list is a very handy tool for someone who is collaborating with other people for data entry in Google Sheets. Why? Well, not only does a drop-down save time and make the data entry process faster, but it also reduces errors and helps in maintaining the uniformity of a Google sheet.
If you are also looking to use a drop-down in Google Sheets, then this post is for you. Here, we will cover the different methods that one can use to add a drop-down in Google Sheets, and will also look at how we can edit, delete and customise drop-down lists.