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

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;

...
[download]

Comment on Re: Excel - how do I format negative Costs in Red Download Code

Replies are listed 'Best First'.
Re^2: Excel - how do I format negative Costs in Red by merrymonk (Hermit) on Feb 02, 2010 at 14:40 UTC
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!	[reply]