Background color on Standard Table Subtotal line

[donschmitz]

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

[rubenmarin]

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.

[donschmitz]

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.