Conditional Formatting

  • Thread starter Thread starter Bullfrog
  • Start date Start date
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.
 
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 2
Conditional Format Range of Cells 3
Conditional Formatting 6
CONDITIONAL FORMATTING QUERY 0
Conditional Formatting ROW not working 6
Conditional Formatting 2
Block cell if specific condition exists 7
Conditional Answer 3

Back
Top