For Example:
I have a text in cell A1 "I have a cat." and in cell B1 "I have a dog." now excel formula or VBA code compare both cells and highlight the specific difference.
in above case, dog and cat should be highlight in same cell.
.
Or another example (one step ahead), if we have data in Number format.
If I have number like "123456789" in cell A1 and "128456789" in cell B1. both looks similar...
but in cell B1 there is one typo mistake at place 3.
Excel compare both cells, and highlight/or change font color/and bold, the specific difference.
in above case... 3rd place digit (in same cell) should be highlight, as in both cells it does not match.
.
Real life scenario is .. if we have data in one column with Original Number (say some Social Security Number, or Contact No.), but in column B, we have same number but with little typo mistake...
maybe somwhere one digit difference, or two digits difference, or might be more... So how to know comparing both columns.... what is actual difference.
*Remember: whole cell should not be highlighted. as we already know. both cells have minor difference.
but we want to know EXACT WHAT IS DIFFERENCE....
I have a text in cell A1 "I have a cat." and in cell B1 "I have a dog." now excel formula or VBA code compare both cells and highlight the specific difference.
in above case, dog and cat should be highlight in same cell.
.
Or another example (one step ahead), if we have data in Number format.
If I have number like "123456789" in cell A1 and "128456789" in cell B1. both looks similar...
but in cell B1 there is one typo mistake at place 3.
Excel compare both cells, and highlight/or change font color/and bold, the specific difference.
in above case... 3rd place digit (in same cell) should be highlight, as in both cells it does not match.
.
Real life scenario is .. if we have data in one column with Original Number (say some Social Security Number, or Contact No.), but in column B, we have same number but with little typo mistake...
maybe somwhere one digit difference, or two digits difference, or might be more... So how to know comparing both columns.... what is actual difference.
*Remember: whole cell should not be highlighted. as we already know. both cells have minor difference.
but we want to know EXACT WHAT IS DIFFERENCE....