Conditional formatting: Cell is higlighted if it contains text from another cell

Hi and welcome to the forum

This is 1 of those times where copy/pasting your info to here, doesnt show real well where 1 cell ends and the next begins

I would suggest uploading a sample workbook
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

An attachment would help, but I think your second example helps clear up where the cell boundaries are.

I would use "Use a formula to determine which cells to format", use this formula, and apply it to $B:$B

Formula:

Please Login or Register  to view this content.

Edit: Well, on second look I am more confused because in your first example you were comparing the value in column B to the value in column A in the same row. In your second example you are comparing B! to A2--different rows.

I second the motion to provide a file and manually highlight it the way you want it to look.