Use Conditional Formatting In Google Sheets

Steps to apply conditional formatting in Google Sheets

• Step 1: Select the range you want, then go to Format and click Conditional formatting

• Step 2: Choose the format rules you want to apply

• Step 3: Type the text you want to highlight, then click Done

Tip: You can combine multiple rules to highlight different types of data within the same range