'以下是在A3:A100区域输入数据时,自动加背景色
Private Sub Worksheet_Change(ByVal Target As Range)
For Each Rng In [a3:a100]
If Rng <> "" Then
Rng.Interior.ColorIndex = 3
End If
Next
End Sub
'以下是在A3:A100区域输入数据时,自动加背景色
Private Sub Worksheet_Change(ByVal Target As Range)
For Each Rng In [a3:a100]
If Rng <> "" Then
Rng.Interior.ColorIndex = 3
End If
Next
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
For Each Rng In [a3:a100]
If Rng <> "" Then
Rng.Interior.ColorIndex = 3
Else
Rng.Interior.Pattern = xlNone
End If
Next
End Sub