Conditional formatting with "contain".
Solved/Closed
Tulsi17
Posts
2
Registration date
Wednesday 15 January 2014
Status
Member
Last seen
15 January 2014
-
15 Jan 2014 à 12:29
Blocked Profile - 15 Jan 2014 à 17:31
Blocked Profile - 15 Jan 2014 à 17:31
Related:
- Conditional formatting with "contain".
- Excel clear formatting - Guide
- Excel conditional formatting based on date - Guide
- Excel conditional formatting dates overdue ✓ - Excel Forum
- Formatting windows 7 - Guide
- Conditional formatting between two values ✓ - 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 15 January 2014
Status
Member
Last seen
15 January 2014
15 Jan 2014 à 16:49
15 Jan 2014 à 16:49
THANK YOU THANK YOU, ac3mark!!! You're the bee's knees!!!! It worked!!! a million thanks!