For now, there is a workaround using the CSV export and Excel.
After using the comparison tool, export the results to a CSV file. Then open the CSV file in Excel and press Alt + F11 to open the Visual Basic Editor. In the left pane, select Insert → Module, and paste the macro code below.
You can save the macro in your Personal Macro Workbook and assign it to a keyboard shortcut for easier access.
Sub Difference()
Dim ws As Worksheet
Dim LastRow As Long
Dim LastCol As Long
Dim r As Long
Dim c As Long
For now, there is a workaround using the CSV export and Excel.
After using the comparison tool, export the results to a CSV file. Then open the CSV file in Excel and press Alt + F11 to open the Visual Basic Editor. In the left pane, select Insert → Module, and paste the macro code below.
You can save the macro in your Personal Macro Workbook and assign it to a keyboard shortcut for easier access.
Sub Difference()
Dim ws As Worksheet
Dim LastRow As Long
Dim LastCol As Long
Dim r As Long
Dim c As Long
Set ws = ActiveSheet
LastRow = ws.Cells(ws.Rows.Count, 1).End(xlUp).Row
LastCol = ws.Cells(1, ws.Columns.Count).End(xlToLeft).Column
ws.Cells.Interior.ColorIndex = xlNone
For c = 3 To LastCol Step 2
For r = 2 To LastRow
If Trim(CStr(ws.Cells(r, c).Value)) <> Trim(CStr(ws.Cells(r, c + 1).Value)) Then
ws.Cells(r, c).Interior.Color = RGB(255, 255, 0)
ws.Cells(r, c + 1).Interior.Color = RGB(255, 255, 0)
End If
Next r
Next c
End Sub