|
本帖最后由 lj2009jl 于 2011-9-29 15:20 编辑
代码如下
- Sub 颜色区分()
- '
- '
- '这里假定要比较的两个工作表的名字分别为sheet1 sheet2
- hang = Application.InputBox("输入要比较的行数", Type:=1) '行数
- lie = Application.InputBox("输入要比较的列数", Type:=1) '列数
- Set o = Sheets("sheet1").Application.Cells(1, 1)
- o.Interior.ColorIndex = 3
- For i = 1 To hang
- For j = 1 To lie
- Set m = Sheets("sheet1").Application.Cells(i, j)
- Set n = Sheets("sheet2").Application.Cells(i, j)
- If m.Value <> n.Value Then
- m.Interior.ColorIndex = 3
- n.Interior.ColorIndex = 3
- End If
- Next j
- Next i
-
- End Sub
复制代码 现象如附件
本帖最后由 mxg825 于 2011-9-29 16:28 编辑
- Sub 颜色区分()
- '这里假定要比较的两个工作表的名字分别为sheet1 sheet2
- hang = Application.InputBox("输入要比较的行数", Type:=1) '行数
- lie = Application.InputBox("输入要比较的列数", Type:=1) '列数
- Set o = Sheets("sheet1").Application.Cells(1, 1)
- o.Interior.ColorIndex = 3
- For i = 1 To hang
- For j = 1 To lie
- Set m = Sheets("sheet1").Cells(i, j)
- Set n = Sheets("sheet2").Cells(i, j)
- If m.Value <> n.Value Then
- m.Interior.ColorIndex = 3
- n.Interior.ColorIndex = 3
- End If
- Next j
- Next i
- End Sub
复制代码
|
-
-
1.rar
172.43 KB, 下载次数: 20
|