ExcelWriter: BgColor of cell is not changing

[ali]

When i set BgColor of cell in format, it only changes to a dark gray color & does not set any specific color which is given as parameter.

please guide me,

thanks,

[mark]

[ali]

i tried
$bg_format = $workbook->AddFormat(array('align' => 'left', 'size'=>9, 'BgColor'=>18 ));

and

$bg_format = $workbook->AddFormat(array('align' => 'left', 'size'=>9, 'BgColor'=>red));

[mark]

According to the following pages, I'd say that you're looking for setFgColor():
http://pear.php.net/manual/en/package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-format.setbgcolor.php
http://pear.php.net/manual/en/package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-format.setfgcolor.php

Using red as a parameter won't work, unless you have defined a constant with this name yourself. 'red' should work.