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.

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.

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.

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.

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.

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.