topic Background color on Standard Table Subtotal line in App Development

Background color on Standard Table Subtotal line

donschmitz — Sat, 16 Nov 2024 06:58:13 GMT

I can change the color of a cell based on a condition but that does not work on the Total line.

Re: Background color on Standard Table Subtotal line

rubenmarin — Fri, 28 Dec 2018 09:55:12 GMT

Hi, can you post the condition you are using?

Note that in total line all dimension values are present, probably one of your conditions can't be checked with all values at the same time.

Re: Background color on Standard Table Subtotal line

donschmitz — Wed, 02 Jan 2019 17:10:03 GMT

The formula for background color works fine for all data except the Totals line.

=IF ( COLUMN(4) > 0 AND COLUMN(5) > 0, GREEN(),
IF ( COLUMN(4) >= 0 OR COLUMN(5) >= 0, YELLOW(),
IF ( COLUMN(4) < 0 AND COLUMN(5) < 0, RED() )))

Basically you can not set a background color on a Total line.