Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
I am not sure if correct group, but here goes. I am not sure if this can be
done easily, but how do I set a cell based on another? Example A1 has text in it, If A1 contains the word 'Digital' I want B1 to have 'DD' entered. Can this be done? I am using Excel 2003, but will be upgrading to 2007 soon. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Hi
Try this in B1 =IF(A1="Digital","DD","") HTH John "Bullfrog" wrote in message ... I am not sure if correct group, but here goes. I am not sure if this can be done easily, but how do I set a cell based on another? Example A1 has text in it, If A1 contains the word 'Digital' I want B1 to have 'DD' entered. Can this be done? I am using Excel 2003, but will be upgrading to 2007 soon. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
This works great if I only have the word Digital in the box, but what if I
have say 'Capitol Digital'. Can it still be done? "John" wrote: Hi Try this in B1 =IF(A1="Digital","DD","") HTH John "Bullfrog" wrote in message ... I am not sure if correct group, but here goes. I am not sure if this can be done easily, but how do I set a cell based on another? Example A1 has text in it, If A1 contains the word 'Digital' I want B1 to have 'DD' entered. Can this be done? I am using Excel 2003, but will be upgrading to 2007 soon. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Hi Bullfrog
Try this one =IF(COUNTIF(A1,"*Digital*"),"DD","") this formula will accept before and after added words. You can remove the * after Digital if you will only get words before Digital. HTH John "Bullfrog" wrote in message ... This works great if I only have the word Digital in the box, but what if I have say 'Capitol Digital'. Can it still be done? "John" wrote: Hi Try this in B1 =IF(A1="Digital","DD","") HTH John "Bullfrog" wrote in message ... I am not sure if correct group, but here goes. I am not sure if this can be done easily, but how do I set a cell based on another? Example A1 has text in it, If A1 contains the word 'Digital' I want B1 to have 'DD' entered. Can this be done? I am using Excel 2003, but will be upgrading to 2007 soon. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Fantastic!! That worked great in every scenerio I tried! Thanks!!!
"John" wrote: Hi Bullfrog Try this one =IF(COUNTIF(A1,"*Digital*"),"DD","") this formula will accept before and after added words. You can remove the * after Digital if you will only get words before Digital. HTH John "Bullfrog" wrote in message ... This works great if I only have the word Digital in the box, but what if I have say 'Capitol Digital'. Can it still be done? "John" wrote: Hi Try this in B1 =IF(A1="Digital","DD","") HTH John "Bullfrog" wrote in message ... I am not sure if correct group, but here goes. I am not sure if this can be done easily, but how do I set a cell based on another? Example A1 has text in it, If A1 contains the word 'Digital' I want B1 to have 'DD' entered. Can this be done? I am using Excel 2003, but will be upgrading to 2007 soon. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
You're welcome
John "Bullfrog" wrote in message ... Fantastic!! That worked great in every scenerio I tried! Thanks!!! "John" wrote: Hi Bullfrog Try this one =IF(COUNTIF(A1,"*Digital*"),"DD","") this formula will accept before and after added words. You can remove the * after Digital if you will only get words before Digital. HTH John "Bullfrog" wrote in message ... This works great if I only have the word Digital in the box, but what if I have say 'Capitol Digital'. Can it still be done? "John" wrote: Hi Try this in B1 =IF(A1="Digital","DD","") HTH John "Bullfrog" wrote in message ... I am not sure if correct group, but here goes. I am not sure if this can be done easily, but how do I set a cell based on another? Example A1 has text in it, If A1 contains the word 'Digital' I want B1 to have 'DD' entered. Can this be done? I am using Excel 2003, but will be upgrading to 2007 soon. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |