Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to I 'write-through' a formula | New Users to Excel | |||
Can you help me write this formula? | Excel Discussion (Misc queries) | |||
how do I write this formula? | Excel Discussion (Misc queries) | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
how do I write a formula for? | Excel Discussion (Misc queries) |