Wildcards with Conditional Formatting?
 

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.

Wildcards with Conditional Formatting?
 

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.

Wildcards with Conditional Formatting?
 

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.

Wildcards with Conditional Formatting?
 

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