In Google Sheets the Conditional Formatting feature provides the ability to format cells if they meet certain conditions, such as if they contain a certain word or a number.
e.g. if a cell contains the string “Yes” make the background green, or “No” make the background red.
To access Conditional Formatting in a Google Sheet:
Apply to Even Rows
Apply to Odd Rows
Apply to Even Columns
Apply to Odd Columns
Then select the Formatting style such as a colour.