Applying conditional formatting in Google Sheets is really simple! The first thing you should do is to navigate to Google Sheets.
2
Once you have your spreadsheet opened, you should select the column or row that you want to apply the conditional formatting to.
3
Then, you should click on "Format".
4
Then, you should select "Conditional formatting" from the dropdown.
5
Then, you should click on the dropdown below "Format rules".
6
You will find many formatting options that can either be applied to text, numbers and even dates! Select the one you need or prefer. In this case, I will be choosing the "text contains".
7
Once you select the type of format you want, click on the "Value or formula" field and type the text that you want to be highlighted.