How to format part of text using phpexcel?

Question

PHP

I am creating a report using phpexcel. It is necessary to make a part of the text in a cell of a different size and set a different color. How to do it?

Answer 1

$fontStyle = [
    'font' => [
        'bold'  => true,
        'color' => ['rgb' => "FF0000"],
        'size' => 15,
        'name' => "Verdana"
    ]
];
$workbook->getActiveSheet()
    ->getStyle("F1:G1")
    ->applyFromArray($fontStyle);