# Add and define a format my $header = $workbook->addformat(); # Add a format ... $header->set_bg_color('yellow'); ... $worksheet->write($row, $col++, $_, $header) for @fields;