Hello. I can't seem to find a way to have Excel look for a 'wild card'
value. For instance, my pivot table columns a 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