G Guest Apr 15, 2005 #1 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 have a report with a running sum column. I want this field to change to a different shade when the running sum is negative.
M Marshall Barton Apr 15, 2005 #2 PLT said: 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. Click to expand... 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 said: 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. Click to expand... 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
G Guest Apr 18, 2005 #3 Thanks. I got it working. Marshall Barton said: PLT said: 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. Click to expand... 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 Click to expand...
Thanks. I got it working. Marshall Barton said: PLT said: 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. Click to expand... 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 Click to expand...
