Highlight cells based on text contained in another Sheet

**hummer123** · 03-11-2016, 04:38 AM

Hi,

I have a list of URLS, like www.google.com/test/ in column A , in sheet 2 , column B I have a list of domains, like google.com , yahoo.com. I am trying to highlight cells in column A if any of the text / domains in column B is contained in A.

I have tried conditional formatting but cannot get it to work.

Any help ?

Thanks

Scott

**Tony Valko** · 03-11-2016, 04:57 AM

Try this...

Sheet1:

A2 = www.google.com/test/
A3 = www.yahoo.com/test/
A4 = www.excelforum.com/test/

Sheet2:

B2 = yahoo.com
B3 = google.com

On Sheet1...

Select the range A2:A4
Conditional Formatting
Use the "Use a formula..." option

Formula: =LOOKUP(1E100,SEARCH(Sheet2!B$2:B$3,A2))

Choose the desired format
OK out

Highlight cells based on text contained in another Sheet

LinkBack

Thread Tools

Rate This Thread

Display

Highlight cells based on text contained in another Sheet

Re: Highlight cells based on text contained in another Sheet

Thread Information

Users Browsing this Thread

Similar Threads

Need help with a conditional formula to highlight cells based on text and numbers

Highlight cells in the first column of each sheet based on a list

highlight cells on sheet 1 if the text is also on sheet 2

highlight cells in sheet 1 based on cells existing in sheet 2

[SOLVED] Return specific text if a different text is contained anywhere in a range of cells

[SOLVED] Can not figure out how to color cells based on the text contained in the cell

Conditional Formating: Highlight Cells Based on Text of Another Cell

Bookmarks

Bookmarks

Posting Permissions