如下代码吧整行影藏改为A列-B列底色变绿

透明世界1987

Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.Column = 3 Then
   If Target.Value = "0" Then
Target.EntireRow.Hidden = True
   End If
   End If
End Sub

怎么把这个代码整行影藏改为 A列-B列自动底色标绿

哥儿-

仅供参考
Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 3 And Target.Value = "0" Then
        Target.Offset(0, -2).Resize(1, 2).Interior.ColorIndex = 4
    End If
End Sub