View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
smonczka smonczka is offline
external usenet poster
 
Posts: 29
Default 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