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 15495 Registration date Monday July 11, 2005 Status Moderator Last seen October 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 15495 Registration date Monday July 11, 2005 Status Moderator Last seen October 23, 2024 1,533
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

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

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

26 responses
Formula for conditional format to color cells
kipp2019 -
TrowaD -

14 responses
What shall i do after formatting my laptop?
upen91 -
jack4rall -

1 response
Conditional Formatting: 3 range of numbers
LCC -
LCC -

2 responses