Wildcards in Google Sheets Conditional Format

If you are using the Text contains or Text does not contain options while performing conditional formatting in the new Google Sheets, you can now use wildcard characters.

Use a question mark to match any one single character:

A text rule containing “B?ll” would format cells with “Bill”, “Bull”, “Bell” or “Ball”, but not with “Bll” or “Buell”.

You can use a single asterisk to match zero or more characters:

A text rule containing “B*ll” would format cells with “Bll”, “Bill”, or “Buell” but not “Billy”.

Click image to enlarge

Click image to enlarge

In the unlikely event that you need to match a question mark or asterisk in a text string, you ‘escape’ the wildcard character by adding a tilde character (~) before it. This tells the application to treat your asterisk or question mark as a literal character, rather than a wildcard.