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.