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.

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

"Kokomojo" wrote:

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.

something like this in the conditional format formula:

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



"Kokomojo" wrote:

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.

One mo

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



Kokomojo wrote:

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.

--

Dave Peterson