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.
