I am generating an excel sheet with PHPExcel, when using conditional formatting with highlight excel cells based on another cell. The conditions works fine. but value shows twice in cell.
Here is my code:
$objConditional43= new PHPExcel_Style_Conditional();
$objConditional43->setConditionType(PHPExcel_Style_Conditional::CONDITION_EXPRESSION)->setOperatorType(PHPExcel_Style_Conditional::OPERATOR_BETWEEN)->addCondition('AND((S46<>AA124))');
$objConditional43->getStyle()->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getEndColor()->setARGB(PHPExcel_Style_Color::COLOR_RED);
$conditionalStyles = $objPHPExcel->getActiveSheet()->getStyle('S46')->getConditionalStyles();
array_push($conditionalStyles, $objConditional43);
$objPHPExcel->getActiveSheet()->getStyle('S46')->setConditionalStyles($conditionalStyles);
Expecting result: I am Expecting result like below