Conditional formatting with "contain".

Solved/Closed
Tulsi17 Posts 2 Registration date Wednesday January 15, 2014 Status Member Last seen January 15, 2014 - Jan 15, 2014 at 12:29 PM
 Blocked Profile - Jan 15, 2014 at 05:31 PM
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.

2 responses

Blocked Profile
Jan 15, 2014 at 03:54 PM
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
1
Tulsi17 Posts 2 Registration date Wednesday January 15, 2014 Status Member Last seen January 15, 2014
Jan 15, 2014 at 04:49 PM
THANK YOU THANK YOU, ac3mark!!! You're the bee's knees!!!! It worked!!! a million thanks!
0
Blocked Profile
Jan 15, 2014 at 05:31 PM
That is what I like to hear! Mark it as solved, please!
0