vba两张表,数据对比,以某一列做标识,比如学号,要求用不同颜色比如高亮整...答:Public Sub 比较不同项变色()Dim c1 As Range, c2 As Range, c As Range, cc As Range Dim r&, d1, n1&, n2&, iColor%, iTimer, tmp '</*---根据实际表格,设置下面的变量值--- Set c1 = Worksheets("sheet1").Range("A:A") '表1的数据位置 Set c2 = Worksheets("sheet2...