Show the mismatch records

There is August and September 2 months data, here i want to match the records by colors,
in aug and Sep data it has 2 fields borrower id and product type,
match 2fields aug & sep suppose if not match it want to show in color in september data,

You can use Conditional Formatting for this. Select all the cells that you want this to apply to, e.g. from A3 to E20, then click on Conditional Formatting | New Rule | Use a formula... , and then put this formula in the box which pops up:

=COUNTIF($A:$A,$D3)=0

Click on the Format button | Fill tab and select a yellow fill, then click OK twice to exit the dialog box. Excel will automatically adjust the cell references to suit the cells you had originally selected, so you only have to do it once.

Hope this helps.

Pete

After further consideration, it would be better to use this formula for the CF condition:

=AND($D3<>"",COUNTIF($A:$A,$D3)=0)

This will avoid blank rows being highlighted.

Hope this helps.

Pete

Here i want to show only which are not same