phpspreadsheet条件格式列A，如果B列的值小于700

require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\IOFactory;

$spreadsheet = IOFactory::load('path/to/your/file.xlsx');

$worksheet = $spreadsheet->getActiveSheet();

$conditionalFormat = new \PhpOffice\PhpSpreadsheet\Style\Conditional();
$conditionalFormat->setConditionType(\PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_CELLIS);
$conditionalFormat->setOperatorType(\PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_LESSTHAN);
$conditionalFormat->addCondition('B1', 700);
$conditionalFormat->getStyle()->getFont()->getColor()->setARGB(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_RED);

$worksheet->getStyle('A1')->setConditionalStyles([$conditionalFormat]);

$writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
$writer->save('path/to/save/file.xlsx');