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
Hi,

I am trying to figure out a way to use conditional formatting to highlight the cells in column A based on the specific text in column B.

I have tried =ISNUMBER(SEARCH("text",B1:B4))=TRUE
but this highlights all of column A, as seen below.


What I want to do is have it formatted like this:

where the cells in column A are only highlighted when the word "text" appears in column B.

So far, I have been unsuccessful.
If this needs to be a macro, that is fine, but the vba code would be appreciated.

Thank you!

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
Hello,

I haven't played with Excel since a long time but I think the formula would be

=ISNUMBER(SEARCH("text",B1))=TRUE