How to Format a Row in Google Sheets if it Contains Some Text

If you have the following Google sheet:

Sample Google Sheet

And you want to colorize all rows with names that contain “Meena”, then follow these steps:

1. Select the range you want to format

2. Select Conditional Formatting

2. Select Add Another Rule

3. Select “Custom formula is”

4. Pick a formatting style