PHPSpreadsheet -条件格式-单元格上的多个条件

use PhpOffice\PhpSpreadsheet\Style\Conditional;
use PhpOffice\PhpSpreadsheet\Style\ConditionalOperatorType;
use PhpOffice\PhpSpreadsheet\Style\ConditionalType;
use PhpOffice\PhpSpreadsheet\Style\Fill;
use PhpOffice\PhpSpreadsheet\Style\Color;

// 获取单元格样式对象
$style = $spreadsheet->getActiveSheet()->getStyle('A1');

// 创建条件格式对象
$conditional1 = new Conditional();
$conditional1->setConditionType(ConditionalType::CELL_VALUE_IS);
$conditional1->setOperatorType(ConditionalOperatorType::BETWEEN);
$conditional1->addCondition('10');
$conditional1->addCondition('20');
$conditional1->getStyle()->getFill()->setFillType(Fill::FILL_SOLID);
$conditional1->getStyle()->getFill()->getStartColor()->setRGB(Color::COLOR_YELLOW);

$conditional2 = new Conditional();
$conditional2->setConditionType(ConditionalType::CELL_VALUE_IS);
$conditional2->setOperatorType(ConditionalOperatorType::LESS_THAN);
$conditional2->addCondition('10');
$conditional2->getStyle()->getFill()->setFillType(Fill::FILL_SOLID);
$conditional2->getStyle()->getFill()->getStartColor()->setRGB(Color::COLOR_RED);

// 将条件格式应用于单元格
$style->setConditionalStyles([$conditional1, $conditional2]);