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.

pen icon

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.

colour drop-down

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.

select the colour

Repeat the same for all options and close the side pane when you are done.

repeat for all options

Output:

result

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.

Similar Reads

What is a Drop-down List and Why use it

A drop-down list is a list of items from which a user can choose an option that gets populated in a cell in a Google Sheet. As an example, here is a drop-down list of several countries. To select a specific country and fill it in the cell, the user simply has to click on that option in the list....

How to Create and Add a Drop-down List in Google Sheets with Preset Values

When you have to add a drop-down with a few options in it, then you can use this simplest and quickest method:...

How to Create and Add a Drop-down List in Google Sheets with Existing Data

Note that in the previous section, we added a few items in the drop-down. Hence, it was feasible to manually type in the options while creating the drop-down. But if you have a long list of items that you would like to add to the drop-down list, then you must follow this method:...

How to Edit or Remove a Drop-Down List in Google Sheets

If you want to edit a drop-down list in Google Sheets, simply follow these steps:...

How to Use Your New Drop-Down List

Using a drop-down list in Google Sheets is very simple. All you have to do is select an option from the drop-down and the data will be populated in the cell....

Additional Tips for Drop-down Lists in Google Sheets

Move Items in a Drop-Down List...

Assign Colours to Items in the Drop-down List

You can assign different colours to the options in the drop-down as follows:...

How to Change the Drop-down Display Style

You can change how a drop-down appears in the sheet. This is how to do it:...

Conclusion

In this post, we saw how we can add a drop-down list in Google Sheets. Drop-downs are a great tool that one must use, especially while working with a team. It not only enhances the user experience but also makes the overall task much more efficient. Google Sheets comes packed with many such great tools and thus, is a great skill to add to your profile....

FAQs

How do I create a drop-down list in Google Sheets with multiple selections? 1. Select cell and click Data >Data Validation > Add rule 2. Set the Criteria to Drop-down > Select Categories 3.Format the Options...