formula is:
=countif(a1,"*total*")0

is one way.

formula is:
=search("total",a1)
or
=find("total",a1)

(find is case sensitive--search is not.)

smonczka wrote:

Does anyone know how to use wildcards with Conditional Formating?

I need to highlight all ROWS in a spreadsheet CONTAINING the word
"Total".

Normaly I would use conditional formating with the following
formula ....

Formula is =$A1="Total" but this will only pick up exact matches.

Thanks,
Steve

--

Dave Peterson