使用VBA打开和关闭条件格式

Sub OpenConditionalFormatting()
    Dim ws As Worksheet
    Set ws = ThisWorkbook.Worksheets("Sheet1") ' 替换为你的工作表名称
    
    ws.EnableFormatConditionsCalculation = True
End Sub

Sub CloseConditionalFormatting()
    Dim ws As Worksheet
    Set ws = ThisWorkbook.Worksheets("Sheet1") ' 替换为你的工作表名称
    
    ws.EnableFormatConditionsCalculation = False
End Sub