How to add conditional formatting to Google Sheets drop-down list

Adding a drop-down list in Google Sheets is a simple trick that can make it exponentially easier for collaborators to fill in data from a handy list of options (instead of having to type everything manually). Not only can this save you and your users time, but it can also prevent users from entering the wrong information into a critical field in your spreadsheet. 

What if, however, you could take those drop-down lists to the next level and make the results of those drop-down selections really stand out? With conditional formatting, you can just that. For example, if a user were to select a particular answer, the resulting cell would automatically have a particular background color. 

Also: How to create a drop down list in Google Sheets

This can be handy if a user were to enter invalid data and the resulting cell could turn red to indicate a problem. Or maybe you simply want to associate a certain selection with a particular format. Thanks to conditional formatting, you can do that.

What is conditional formatting?  

Simply stated, conditional formatting formats a cell based on specific conditions. In the example I will show you, the conditional formatting will add a background color to a cell based on the color chosen from the drop-down. For instance, if the color red is chosen from the drop-down, the background color for that cell will automatically be, you guessed it, red. 

Of course, you aren’t limited to only adding colors to your cells, as you can also use other (basic) formatting, such as bold, italics, underline, strikethrough, and change the color of the text. 

Conditional formatting also allows you to apply the formatting based on several conditions, such as:

• If a cell is or is not empty.
• Contains (or does not contain) specific text or formula.
• Text starts or ends with specific text or formula.
• Dates.
• Greater than, less than, or equal to.

You can add a single rule or even multiple rules to your conditional formatting. 

Let’s see how this is done.

How to add conditional formatting to Google Sheets

Remember, in the tutorial for adding drop-down lists, we created a list of the following colors:

• Blue.
• Red.
• Green.
• Yellow.
• Black.
• Orange.
• Purple.
• White.

Now we’re going to use conditional formatting to set the cell’s background color based on the color chosen. So, if a collaborator chooses green from the drop-down, the cell background color will be set to green.

Also: How to create a drop-down list in Excel — quickly and easily 

Simple.

And that, my fellow Google Sheets users, is how you add conditional formatting to a drop-down list. You’re not limited to drop-downs for this feature, as you can apply it to any type of call (and even a range of cells). Enjoy the fresh taste of automated formatting.