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
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
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Which example represents cell data with the date format applied to it? - Excel Forum
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!