Excel: Compare two sentences and highlight in different color


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.

this is the my house this is huge the house
tests are normal tests normal
there is a small pot this is pot
this is sum this is huge sum
Just be to change addresses in the below to match your worksheet. Just be sure to the change addresses in the lines to match worksheet.
Since added requirements in the comments below, I modified the code to also print out the list of red-highlighted phrases in column C. If you want this list elsewhere, you'll have adjust the address in the last section of the code. I also improved code Since you added requirements in the comments below, I modified the code to also print out the list of red-highlighted phrases in column C. If you want this list elsewhere, you'll have to adjust the address in the last section of the code. I also improved the highlighting code


This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of September 12, 2014.


For more resources for Microsoft Excel