Conditional Formatting: column A based on text values in columnB
Closed
ceeubank
Posts
1
Registration date
Tuesday 8 July 2014
Status
Member
Last seen
8 July 2014
-
8 Jul 2014 à 08:36
BunoCS Posts 436 Registration date Monday 11 July 2005 Status Moderator Last seen 18 May 2026 - 8 Jul 2014 à 09:06
BunoCS Posts 436 Registration date Monday 11 July 2005 Status Moderator Last seen 18 May 2026 - 8 Jul 2014 à 09:06
Related:
- Conditional Formatting: column A based on text values in columnB
- 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
1 response
BunoCS
Posts
436
Registration date
Monday 11 July 2005
Status
Moderator
Last seen
18 May 2026
1,534
8 Jul 2014 à 09:06
8 Jul 2014 à 09:06
Hello,
I haven't played with Excel since a long time but I think the formula would be
=ISNUMBER(SEARCH("text",B1))=TRUE
I haven't played with Excel since a long time but I think the formula would be
=ISNUMBER(SEARCH("text",B1))=TRUE

