使用条件格式和多个规则

import openpyxl
from openpyxl.styles import PatternFill
from openpyxl.formatting.rule import ColorScaleRule, CellIsRule, FormulaRule

# 加载Excel文件
wb = openpyxl.load_workbook('example.xlsx')
ws = wb.active

# 设置单元格值条件格式
red_fill = PatternFill(start_color='FF9999', end_color='FF9999', fill_type='solid')
rule = CellIsRule(operator='greaterThan', formula=['10'], fill=red_fill)
ws.conditional_formatting.add('A1:A10', rule)

# 设置公式条件格式
green_fill = PatternFill(start_color='99FF99', end_color='99FF99', fill_type='solid')
formula_rule = FormulaRule(formula=['A1>5'], fill=green_fill)
ws.conditional_formatting.add('B1:B10', formula_rule)

# 保存文件
wb.save('example_with_conditional_formatting.xlsx')