Re: Excel - how do I format negative Costs in Red

[hominid]

Not sure if this is the direction that you want to go, but I have done something similar using Excel's conditional formatting. Here is an example that sets the font to red for all cells in the selected range that have a value less than zero:

....

$Sheet->Range("A1")->{Value} = '$5.00';
$Sheet->Range("B1")->{Value} = '$-3.51';
$Sheet->Range("C1")->{Value} = '$-0.01';

my $selection = $Sheet->Range("A1:C1");

$selection->{FormatConditions}->Delete;
$selection->{FormatConditions}->Add(xlCellValue, xlLess, "0");
$selection->FormatConditions(1)->Font->{ColorIndex} = 3;

...

[merrymonk]

I could use that if all else fails.
I guess I was hoping that a diffrent format definition would have done the trick but then perhaps not!