ç»åºå¦ä¸å¾è¡¨æ ¼å¼ï¼å»ºè®®ç¬¬ä¸å第ä¸è¡æ°æ®ä¸ä¸ºç©ºï¼ä¸¤ä¸ªå·¥ä½è¡¨åå«ä¸ºsheet1ãsheet2ï¼ï¼
è¿è¡ä»¥ä¸VBA代ç ï¼
Sub imS()
Sheet1.Activate
For R = 1 To Range("A1").End(xlDown).Row
For C = 1 To Range("A1").End(xlToRight).Column
If Cells(R, C).Value <> Sheets(Sheet2).Cells(R, C).Value Then
'FINDME Q2124102
Cells(R, C).Interior.Color = RGB(31, 162, 195)
End If
Next
Next
End Sub
'----å¦æ两个表对åºåå æ ¼å 容ä¸ä¸è´ï¼æ 注èæ¯è²----