Previous Topic Next Topic

Conditional Formatting: column A based on text values in columnB

Closed
ceeubank Posts 1 Registration date Tuesday July 8, 2014 Status Member Last seen July 8, 2014 - Jul 8, 2014 at 08:36 AM
BunoCS Posts 15475 Registration date Monday July 11, 2005 Status Moderator Last seen April 23, 2024 - Jul 8, 2014 at 09:06 AM
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

Answer 1 / 1
BunoCS Posts 15475 Registration date Monday July 11, 2005 Status Moderator Last seen April 23, 2024 1,534
Jul 8, 2014 at 09:06 AM
Hello,

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

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

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses