Wildcards with Conditional Formatting?

K

Kokomojo

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

Mike

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
 
V

Vergel Adriano

something like this in the conditional format formula:

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