=countif($A1,"*total*")=1

--
Regards,
Tom Ogilvy

"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