Conditional formatting with "contain".
Solved/Closed
Tulsi17
Blocked Profile - Jan 15, 2014 at 05:31 PM
- Posts
- 2
- Registration date
- Wednesday January 15, 2014
- Status
- Member
- Last seen
- January 15, 2014
Blocked Profile - Jan 15, 2014 at 05:31 PM
Related:
- Conditional formatting with "contain".
- Conditional formatting if cell does not contain specific text ✓ - Forum - Excel
- Conditional formatting if another cell contains any text ✓ - Forum - Excel
- Excel conditional formatting 5 color scale ✓ - Forum - Excel
- Copy conditional formatting from one row to another ✓ - Forum - Excel
- If cell contains date then conditional format - Guide
2 replies
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
Jan 15, 2014 at 04:49 PM
- 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!