Conditional formatting with "contain".Solved/Closed

Question

Hello...I am using Excel 2007.  I can't get beyond the following:  =ISNUMBER(SEARCH("campaign",A2))=TRUE

This is what I'm trying to do...If cell A2 contains the word campaign, then return the complete entry for cell A2 (whatever is in cell A2); otherwise, enter "Employee Referral".  Of course, the above format formula merely returns the word "True".  So I tried to manipulate it by doing the following:

=ISNUMBER(SEARCH("campaign",A2)), "Employee Referral", and it really didn't like that.  I don't know how to ask this question.

Can anyone help?  Thank you.

ac3mark · Answer

Ok, hang in there.

Give this a go:
=IF(ISNUMBER(SEARCH("campaign",A2)),A2,"employess referral")


The logic for IF is as followS:
=if(logic_test,true,false)


Have FUN!

Post back! 
 
//ark
-Moderator/Contributor

Tulsi17 · Answer

THANK YOU THANK YOU, ac3mark!!!  You're the bee's knees!!!!  It worked!!!  a million thanks!

Conditional formatting with "contain".

2 replies

Subscribe To Our Newsletter!