Add Color to Dropdown List

  • Reading time:2 mins read
  • Post category:Utility
  • Post comments:0 Comments

Dropdown lists is a very handy tool to promote data standardization and provide ease of input to Google Sheet users. There are multiple ways to create a dropdown list which we have covered here.

In this tutorial we will understand the process of adding a cell color depending on the option selected in the dropdown list. We will be using conditional ‘ formatting to achieve this objective.

Sample Colored Dropdown Sheets

Sample Google Sheet File

In this tutorial we will be using the below Google Sheet Document to work. Feel free to create a copy for yourself.

Add color to Dropdown List

Creating a Dropdown Lists

To those who are new to the concept of Data Validation and Dropdown Lists you can get visit below links.

  1. How to Create a Dropdown Lists
  2. How to Edit a Dropdown List

Or, a quick recap below would also be useful to juggle the memory.

Creating Dropdown Sheet using List of Items Option

Creating Dropdown List 1

Creating Dropdown Cells using Cell Range Option

Creating Dropdown list 2
Creating Dropdown list 3

Adding Conditional Formatting to Cell

To add color to Dropdown lists follow the below steps:-

  1. Create a Dropdown Lists in a cell
  2. Select the cell , Goto Format -> Conditional Formatting
  3. Select the Rule, Add the value & decide the formatting
  4. Repeat step 3 for all possible dropdown options

Lets deep-dive into individual steps in more detail.

Step 1: Create a Dropdown list

Follow the instruction in previous steps to create a dropdown list. For the purpose of this exercise we shall create a simple dropdown list with three options, “Yes”, “No”, “Maybe”

Create Dropdown Lists

Step 2: Open conditional Formatting Option

Goto Format -> Conditional Formatting

Open Conditional Formatting Option

Step 3: Add Conditional Formatting Rules

Lets say, I am looking for the below formatting against the dropdown optional selected

YES -> Green

NO -> Red

MAYBE -> Yellow

Lets start with the implementing the first rule.

In the “Format Cells if” select “Text is Exactly” and then enter “Yes”. Lastly goto Formatting style and select Green fill. In a similar way you can workout for the other two options as well.

Applying Conditional Formatting 1
Formatting for “Yes”

Applying Conditional Formatting 2
Formatting for “No”

Apply Conditional Formatting 3
Formatting for “Maybe”

Once the above steps are completed, we would now be able to select dropdown options with automatic color fill basis selection.

Colored Dropdown Sheets

That’s it on this topic. If you face any issues in implementing the above methods then leave a comment down below. Keep browsing SheetsInfo for more such useful information 🙂

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Liked the content?? Then share the word!!!

Rishav

I love Google Sheets and heavily rely upon it on a day to day basis. SheetsInfo is my attempt to share my learning with all of you. Hope you find the articles easy to read and simple to understand.

Leave a Reply