highlight difference between two text values excel

[chrisbevan4]

Hello

I am trying to find out how I can compare a text value in one cell to another and high light the differences

formula =exact(a1,b1) gives me true or false

But I need to identify what part of the text value is different and
need it to be case sensitive as well, I have got a sample of the data below

<table style="width: 671px; height: 273px;" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="width:48pt" span="2" width="64"> <col style="mso-width-source:userset;mso-width-alt:5404;width:114pt" width="152"> <col style="mso-width-source:userset;mso-width-alt:5745;width:121pt" width="162"> </colgroup><tbody><tr style="height:14.4pt" height="19"> <td style="height:14.4pt;width:48pt" height="19" width="64">A1</td> <td style="width:48pt" width="64">B1</td> <td style="width:114pt" width="152">True or False</td> <td style="width:121pt" width="162">Why they are different</td> </tr> <tr style="height:14.4pt" height="19"> <td style="height:14.4pt" height="19">test 123</td> <td>test 123</td> <td align="center">FALSE</td> <td>Two spaces</td> </tr> <tr style="height:14.4pt" height="19"> <td style="height:14.4pt" height="19">123 Test</td> <td>123 test</td> <td align="center">FALSE</td> <td>Two spaces and Capital T</td> </tr> <tr style="height:14.4pt" height="19"> <td style="height:14.4pt" height="19">a1 - 1234</td> <td>a1 - 123</td> <td align="center">FALSE</td> <td>Two spaces</td> </tr> <tr style="height:14.4pt" height="19"> <td style="height:14.4pt" height="19">A1 - 123</td> <td>a1 - 123</td> <td align="center">FALSE</td> <td>Two spaces and Capital T</td> </tr> <tr style="height:14.4pt" height="19"> <td style="height:14.4pt" height="19">test 124</td> <td>test 124</td> <td align="center">TRUE</td> <td>exact match</td> </tr> <tr style="height:14.4pt" height="19"> <td style="height:14.4pt" height="19">Test 12</td> <td>Test 12</td> <td align="center">TRUE</td> <td>exact match</td> </tr> </tbody></table>

Any help advise would be appreciated

<table style="width: 83px; height: 81px;" border="0" cellpadding="0" cellspacing="0"><tbody><tr style="height:14.4pt" height="19"><td style="height:14.4pt;width:48pt" height="19" width="64">
</td><td style="width:48pt" width="64">
</td><td style="width:114pt" width="152">
</td><td style="width:121pt" width="162">
</td></tr><tr style="height:14.4pt" height="19"><td style="height:14.4pt" height="19">
</td><td>
</td><td align="center">
</td><td>
</td></tr><tr style="height:14.4pt" height="19"><td style="height:14.4pt" height="19">
</td><td>
</td><td align="center">
</td><td>
</td></tr><tr style="height:14.4pt" height="19"><td style="height:14.4pt" height="19">
</td><td>
</td><td align="center">
</td><td>
</td></tr><tr style="height:14.4pt" height="19"><td style="height:14.4pt" height="19">
</td><td>
</td><td align="center">
</td><td>
</td></tr><tr style="height:14.4pt" height="19"><td style="height:14.4pt" height="19">
</td><td>
</td><td align="center">
</td><td>
</td></tr><tr style="height:14.4pt" height="19"><td style="height:14.4pt" height="19">
</td><td>
</td><td align="center">
</td><td>
</td> </tr> </tbody></table>