Private Sub Worksheet_Change(ByVal Target As Range)
'>>> A6:C27根据C2填充背景色
Dim i As Integer
If Target.Address = "$C$2" Then
[a6:a27].Interior.ColorIndex = 0
For i = 6 To 27
If Cells(i, 1) = [c2] Then Cells(i, 1).Interior.ColorIndex = 35 '浅绿色
Next i
End If
'<<<