如何创建在满足2个条件/单元格(有多个目标地址)时隐藏单元格的宏

Sub HideCellsBasedOnConditions()
    Dim ws As Worksheet
    Dim cell As Range
    
    ' 设置工作表
    Set ws = ThisWorkbook.Worksheets("Sheet1") ' 将"Sheet1"替换为你的工作表名称
    
    ' 遍历每个单元格
    For Each cell In ws.UsedRange
        ' 检查条件并隐藏单元格
        If cell.Value = "条件1" And cell.Offset(0, 1).Value = "条件2" Then ' 替换"条件1"和"条件2"为你的条件
            cell.EntireRow.Hidden = True ' 隐藏整行
            ' 或者使用以下代码隐藏整列
            ' cell.EntireColumn.Hidden = True
        End If
    Next cell
End Sub