conditional format for running sum

[PLT]

I have a report with a running sum column. I want this field to change to a
different shade when the running sum is negative.

 

[Marshall Barton]

I have a report with a running sum column. I want this field to change to a
different shade when the running sum is negative.

I recommend using conditional formatting (Format menu) for
this.

Another way to get a different fore color for a negative
value is to use a custom format in the text box's Format
property. E.g. #,##0;[RED]-#;##0;0

 

[PLT]

Thanks. I got it working.

I have a report with a running sum column. I want this field to change to a
different shade when the running sum is negative.

I recommend using conditional formatting (Format menu) for
this.

Another way to get a different fore color for a negative
value is to use a custom format in the text box's Format
property. E.g. #,##0;[RED]-#;##0;0