Write formula to look for 'like' value

[Guest]

Hello. I can't seem to find a way to have Excel look for a 'wild card'
value. For instance, my pivot table columns are: I'm trying to conditional
format column B bold if it is a Total column. Example below. Hope someone
can help. Many thanks!

A B

Smith Total 14 =if(a1="Total",true) the names will change and i
want the
Smith Actual 19 format to be based
soley on the text
Jones Total 0 'Total'.
Bean Total 10
Bean Actual

 

[Peo Sjoblom]

use

=ISNUMBER(SEARCH("Total",A1))

for the formula is box in your formatting

 

[Guest]

Worked like a charm, thank you very much for your help.