conditional formatting , total values in red if they are negative?

[wrathskyl]

is it possible to make the total values in a table red if they are negative? i could use conditional formatting to make the individual cells within each column to appear red the if the value was negative but I cant seem to change the grand total

[Rayshin · Accepted solution]

@wrathskyl In conditional format settings there's an option in the top right for it to affect either values, totals or both. If you set it to totals, it should work for grand total.

[wrathskyl]

@Rayshin Thank you, i didn't see this.