Hi all,
I want to compare two cells in excel using macro and populate the difference after executing the macro. I have attached my compare diff.xls how my cells has to be highlighted after executing the macro.
If any body has worked on this requesting your help in this regard.
Thanks and in advance.
This is a basic one, simply comparing what's in column A but not in B, and vice versa, and showing all on column C. It's not going to compare/highlight based on relative word position in the sentence (i.e. repeated words will not be detected). This just a rough one to get you going, you can make changes to your needs.
Last edited by millz; 09-15-2014 at 11:30 AM. Reason: Removed code because apparently OP doesn't read, and most likely will not use this anyway.
多么想要告诉你 我好喜欢你
hi millz,
below two columns not showing proper difference.
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
hi milz,
color marked in red not showing in the code sent
Good luck sir, anyone who has read your posts in one of the other cross posts most likely is not going to help too. I am out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks