Wildcards with Conditional Formatting?

[Guest]

Is is possible to use Wildcards with Conditional Formatting? I would like to
highlight cells that contain a particular text string, but not necessarily
contain just the text string.

I know that I can do this with an =IF function or with filtering, but I'd
like to do this with Conditional Formatting.

Thanks so much.

 

[Guest]

Yes it is.

Using A1 In the conditional formatting wizard select formula is and enter

=ISNUMBER(SEARCH("dog",A1))

The format you select will now be displayed if the text dog appears in the
cell i.e.

Bulldog
dogs
dog eared
etc

Mike

 

[Guest]

something like this in the conditional format formula:

=NOT(ISERROR(FIND("sometext", A1, 1)))

 

[Dave Peterson]

One more:

=countif(a1,"*particular text string*")>0