Tech Secrets

How to Highlight Cells Containing Specific Text in Google Sheets

googlesheets-619x350Google Sheets has an integrated conditional formatting program which allows one to establish guidelines which will pick tissues out that match with your standards and structure them according to your own specs. It is possible to use conditional formatting to structure Low-Blank Tissues, beliefs below or above thresholds also custom formulations, or you set. In this guide, I am going to walk you through the best way to emphasize cells containing text that is particular. I generate a conditional format rule which will emphasize all the cells which contain the phrase “Wal-Mart.” and will use an illustration listing of places

1.Highlight the range of cells to which you want to apply the conditional formatting. Go to Format>Conditional Formatting.


2.The Conditional format rules panel appears on the right side of the screen. Click Add new rule.


Heck whether the amounts in the Use to array carton to see are not incorrect. If maybe not, click choose or for the reason that place to sort in the right variety it. You can even include several amounts to which the guideline applies. That is beneficial because this means so, as soon as you create this principle, it can be used by you during your book with the addition of amounts to the principles.


4.Now use the Format cells if… box to create your rule. For the purposes of this tutorial, I will choose Text Contains and type in Walmart under that. Other options for text conditional formatting include:

  • Text does not contain
  • Text starts with
  • Text ends with
  • Text is exactly
  • 4

5 Today establish. It is possible to pick a default choice or by hand pick the typeface colour, mobile back ground colour, and text results (boldface, italics, underline, and strike through). Sadly, you CAn’t alter or now add edges utilizing conditional format in Google Linens. The default format, which can be a mild green spotlight will be kept by me.5

6.Your rules are shown real time in your spreadsheet. When everything is working to your liking, click Done.


Related posts

10 Ways to Open the Command Prompt in Windows 10

Farooq Ahmed

How to Restore Older Version of Google Slides Presentation

Farooq Ahmed

How to Play the Secret Basketball Game in Facebook Messenger


Leave a Comment