Private Sub Worksheet_SelectionChange(ByVal Target As Range)
' 如果选择多于一个单元格,或者单元格为空,则直接退出
If Target.Cells.Count > 1 Or Target = "" Then Exit Sub
Cells.FormatConditions.Delete ' 清除原有条件格式
' 设置条件格式,当前工作表中的所有与选定单元格内容相同的单元格都变成绿色背景
Cells.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=AND(" & Target.Address(False, False) & "=" & Target.Address & ", COUNTIF(" & Target.Row & ":" & Target.Row & "," & Target.Address & ")>1)"
Cells.FormatConditions(1).Interior.Color = vbRed
' 设置条件格式,当前工作表中的所有与选定单元格内容相同的单元格都变成绿色背景
Cells.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=" & Target.Address(False, False) & "=" & Target.Address
Cells.FormatConditions(2).Interior.Color = vbGreen
End Sub
温馨提示:答案为网友推荐,仅供参考