Compare two sentences and highlight in different color using VBA

[vlnmca]

[h=2]Hi all,

I want to compare two cells in excel using macro and populate the difference after executing the macro.

If any body has worked on this requesting your help in this regard.

If I add paragraph comparison between two cells is not working.

I have attached the excel with data and macro, Kindly provide solution.
[/h]

 

[snb]

crossposted at at least 5 fora, including

http://www.vbaexpress.com/forum/sho...ifferent-color&p=315185&viewfull=1#post315185