excelrater
New Member
- Joined
- May 17, 2019
- Messages
- 21
How do I get excel to Highlight words that have the same first two characters from two different cells
For example
<tbody>
</tbody>
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>