Conditional Formating...
 

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

Conditional Formating...
 

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

or use the search command.

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