I need a macro to highlight a column having a word which is another column's entry

[Athi123]

I need a macro to highlight a column having a word which is another column's entry.

For example,

Column 1 is having a sentence "Spectracide Cleaning Solution" and Column 2 is having the Word "Spectracide".

I want to highlight the column 1 to show that it has the word repeated from Column 2.

Please help me to create a macro for the same.

Thanks

[jraj1106]

Hi.

Try this code:

Please Login or Register  to view this content.

[Athi123]

Hi,

Thanks for the macro.

I have 2 columns A and B. In column B some entries are blank. When I run the macro, along with the Duplicated text, the entry in Column A gets highlighted which have no entry in column B.

Please help me to solve this issue.

Thanks.

[jraj1106]

So if col B is empty then no highlighting. Is that what you want?

[jraj1106]

Now check this code:

Please Login or Register  to view this content.

[Athi123]

Hi,

Thanks a lot. Now it's working fine.

[jraj1106]

You are welcome.

Please click star below. Thanks..