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”.
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.