how to change cell color in google sheets based on text

If you're looking for a way to highlight information in your Google Sheets document, conditional formatting is an excellent…