Highlight words that have the same first two characters from two different cells

[excelrater]

How do I get excel to Highlight words that have the same first two characters from two different cells

For example

	A	B
1	abfgr( this should highlighted since the same first two letters is found in cell B2)	gh( this should highlighted since the same first two letters is found in cell A3)
2	bdnm (this should not be highlighted since none had the same first two letters)	ab( this should highlighted since the same first two letters is found in cell A1)
3	ghfd( this should highlighted since the same first two letters is found in cell B1)	cb (this should not be highlighted since none had the same first two letters)

<tbody>
</tbody>

 

[DanteAmor]

Re: How do I get excel to Highlight words that have the same first two characters from two different cells

I'm glad to help you. Thanks for the feedback.