Problem with finding duplicating words in two columns in Excel 2007

[emil9216]

I have a problem when i have to find duplicating words in two columns. It doesn't highlight the duplicated words if they are in combination with other words. For example, if in cell A1 is the word "diet plan" and in the cell B2 is the word "diet recipe" it won't highlight the word "diet" as a duplicate. I am using this way to find duplicates - Conditional Formatting>Highlight cells rules>Duplicate values... but it doesn't work.

I want to highlight all type words from column A that have duplicates in column B and not just the words that are in the same rows.

How to do this?


Thanks!

 

[RSXchin]

well, the reason the values aren't being highlighted, is because they aren't duplicate values.

It looks at the cell value as a whole.

 

[mikerickson]

Is this the same issue as in
http://www.ozgrid.com/forum/showthread.php?t=152697

Is the solution offered there working?