Conditional Formatting

B

Bullfrog

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.
 
B

Bullfrog

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?
 
J

John

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
 
Top