How to Highlight Text that Contain Multiple Strings in Google Sheets

You often need to highlight the text in Google sheets based on certain rules. The same as highlight text contains a single text string, you need to add more rules if you want to highlight the cells that contain multiple strings in the spreadsheet.

Step 1: Select the text or the data range that you want to highlight;

Step 2: Click the "Format" tab from the ribbon;

Step 3: Click the "Conditional formatting" from the drop-down list;

Step 4: On the right of your spreadsheet, you will see the "Conditional format rule" panel. In the "Format rules" box, select "Text contains" and type the first text string, e.g., "on";

Step 5: If you want a different color from the default color, you can change the color in the "Formatting style" section;

Step 6: After you click the "Done" button, the text that contains the first text string you entered should be in the proper color, e.g., green;

Step 7: In the right panel, click "Add another rule";

Step 8: In the new rule panel, select the same data range, and in the "Format rules" box, select "Text contains" and type the second text string, e.g., "li";

Step 9: In the "Formatting style" section, you can decide to have the same or different color from the cells contain the first string.

Step 10: Click the "Done" button and you will see the cells with both strings are now in color.

Leave a Reply