CODEWITHSUNDEEP
excelpandasvbagoogle-sheets
Bingold Axel
Bingold Axel

Reputation: 65

Excel formula or rules or vba to compare 2 cells and to highlight only the differences

Is there any Excel formula or rules or vba to compare 2 cells and to highlight only the differences in another cell or in same cell.

I've two columns column A and column B with each row containing different text data in my excel,

Example

Cell A2 contains the text "My name is Bingold Axel"

And cell B2 contains "My name is Axel"

When I type in exact formula in C2 it just returns true or false...

Whereas I want the specific word "Bingold" (as this is the only difference between 2 cells) to be printed on c2 or in the cell A2 the word "Bingold" alone should turn to red font

Any idea how it can be done with excel or do we need pandas?

Upvotes: 2

Views: 327

Answers (1)

player0
player0

Reputation: 1

try:

=FILTER(SPLIT(A2, " "), NOT(COUNTIF(SPLIT(B2, " "), SPLIT(A2, " "))))

enter image description here

Upvotes: 2

Related Questions