第1个回答 2008-10-28
复制下面的代码,工具栏->宏->录制新宏->输入一个宏名(找同号)->确定,然后工具栏->宏->停止录制宏:按Alt+F11,将下面代码粘贴,再按F5运行该宏,回到表格看看吧。
Sub 找同号()
Range("A:A").Sort Key1:=Range("A1"), Order1:=xlAscending, Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
SortMethod:=xlPinYin, DataOption1:=xlSortTextAsNumbers
row_num = Sheet1.UsedRange.Rows.Count
For i = 1 To row_num - 1
haoma = Cells(i, 1).Value
While Sheet1.Cells(i + 1, 1) = haoma
i = i + 1
Cells(i, 1).Font.ColorIndex = 3
Wend
Next
End Sub
第2个回答 2008-10-28
点工具《宏《visul basic 编辑器《 在编辑器里双击你资料所在的工作表,在代码处输入以下内容:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim a, b, c As Double
c = Me.Range("a65536").End(xlUp).Row
For a = 1 To c
For b = a + 1 To c
If Me.Cells(b, 1) = Me.Cells(a, 1) Then
Me.Cells(b, 1).Interior.Color = 0
End If
Next b
Next a
MsgBox "计算完毕!", , "提示"
End Sub
这样就好了,之后就把这代码删掉。本回答被提问者采纳