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
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.
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.
Related:
- Conditional formatting with "contain".
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- How to format windows 7 with keyboard - Guide
- Formatting usb mac - Guide
- Code for formatting android phone - Guide
2 responses
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
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
Posts
2
Registration date
Wednesday January 15, 2014
Status
Member
Last seen
January 15, 2014
Jan 15, 2014 at 04:49 PM
Jan 15, 2014 at 04:49 PM
THANK YOU THANK YOU, ac3mark!!! You're the bee's knees!!!! It worked!!! a million thanks!