Write formula to look for 'like' value
 

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

Write formula to look for 'like' value
 

use

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

for the formula is box in your formatting


--
Regards,

Peo Sjoblom


"Suzanne" wrote in message
...
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

Write formula to look for 'like' value
 

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

"Peo Sjoblom" wrote:

use

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

for the formula is box in your formatting


--
Regards,

Peo Sjoblom


"Suzanne" wrote in message
...
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