How can I use multiple text values to create conditional formatting in Google Sheets?

By /

Conditional formatting in Google Sheets allows users to automatically change the formatting of cells based on certain conditions. In order to use multiple text values to create conditional formatting, the user can use the “Custom formula is” option in the conditional formatting menu. By inputting a formula that includes multiple text values, the user can specify which cells should be formatted based on their contents. This feature is particularly useful for organizing and highlighting data in a visually appealing and efficient manner. With the ability to use multiple text values, users can create customized and dynamic conditional formatting rules to suit their specific needs.

Google Sheets: Conditional Formatting Based on Multiple Text Values

You can use the custom formula function in Google Sheets to apply conditional formatting to cells based on multiple text values.

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

Example: Conditional Formatting Based on Multiple Text Values in Google Sheets

Suppose we have the following dataset in Google Sheets that shows the position and points scored by various basketball players:

Now suppose we would like to apply conditional formatting to each cell in the Position column that contains one of the following specific texts:

  • Starting
  • Forward
  • Center

To do so, we can highlight the cells in the range A2:A11, 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:

=regexmatch(A2, "(?i)starting|forward|center")

Google Sheets conditional formatting based on multiple text values

Once you click Done, each of the cells in the Position column that contains either Starting, Forward, or Center will automatically be highlighted:

Note: We chose to use a light green fill for the conditional formatting in this example, but you can choose any color and style you’d like for the conditional formatting.

Additional Resources

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

x

Related terms:

  1. How to do conditional formatting in google sheets if another cell contains text?
  2. How can I apply conditional formatting to Yes/No values in Google Sheets?
  3. How to do conditional formatting with multiple conditions in Google Sheets?
  4. How can I use conditional formatting to highlight Yes/No values in Google Sheets?
  5. How can I use conditional formatting in Google Sheets to highlight cells that are greater than or equal to a certain value?
  6. How do I apply conditional formatting to a text column in Power BI?
  7. How can I apply conditional formatting in Excel to highlight cells that contain partial text?
  8. How to use conditional formatting based on checkbox in Google Sheets?
  9. Another Cell How can I use conditional formatting in Google Sheets to highlight a cell if it is equal to or greater than another cell?
  10. How can I apply conditional formatting to a text column in Power BI?