How can I apply conditional formatting to Yes/No values in Google Sheets?

By /

Conditional formatting in Google Sheets allows users to automatically format cells based on specific conditions or criteria. This feature can also be applied to Yes/No values in order to visually distinguish them from other data. To do this, users can select the cells containing the Yes/No values and then click on “Format” and select “Conditional formatting.” From there, they can set the condition to “Text contains” and enter “Yes” or “No” as the text to be formatted. This will allow the cells to be automatically formatted with a specific color or style when the value is either “Yes” or “No.” This can be useful for organizing and analyzing data in a more efficient and visually appealing manner.

Google Sheets: Apply Conditional Formatting to Yes/No Values

You can use the custom formula function in Google Sheets to apply conditional formatting to cells based on whether they contain “Yes” or “No” in them.

The following example shows how to use the custom formula function in practice.

Example: Conditional Formatting if Another Cell Contains Text in Google Sheets

Suppose we have the following dataset in Google Sheets that shows whether or not various basketball players are All-Stars:

Suppose we would like to use conditional formatting to apply a green background to each cell with a value of “Yes” and a red background to each cell with a value of “No” in in the All-Star column.

To do so, we can highlight the cells in the range B2:B13, then click the Format tab, then click Conditional formatting:

In the Conditional format rules panel that appears on the right side of the screen, click the Format cells if dropdown, then choose Custom formula is, then type in the following formula:

=B2="Yes"

Then click Done.

Then click Add another rule:

Then click the Format cells if dropdown again, choose Custom formula is, then type in the following formula:

=B2="No"

Google Sheets conditional formatting for yes/no values

From the output we can see:

  • Each cell with a value of “Yes” in the All-Star column has a green background
  • Each cell with a value of “No” in the All-Star column has a red background

Note: If any cell in the All-Star column had a value other than “Yes” or “No”, it would simply keep a white background color.

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

x

Related terms:

  1. Excel: Apply Conditional Formatting to Yes/No Values
  2. How can I use conditional formatting to highlight Yes/No values in Google Sheets?
  3. Student asks: How do I apply conditional formatting to duplicate values?
  4. How to Apply Conditional Formatting if Between Two Values
  5. Excel: Apply Conditional Formatting to Second Highest Value
  6. Excel: Apply Conditional Formatting to Dates Older Than 1 Year
  7. How to Apply Conditional Formatting to Dates within 6 Months in Excel
  8. How to Apply Conditional Formatting Based on Adjacent Cell in Excel?
  9. How to apply conditional formatting if two cells are not equal
  10. How can I apply conditional formatting to a text column in Power BI?