How to use row rule for 1 specific row?

Hello,

I have a chart that input to an email, and I have a total row at the bottom that shows my numbers tie out. I was to chance the background color to green if the tie out and red if they don't. Whenever I try to do a row rule, it applies to the total column as well. Any tips on this?

Here is the chart for reference:

new chart.jpg

Thank you so much everyone has been so helpful!

-e

Developer Tools

Output

Accepted answers

@hoye sorry try removing the 'IF'

All comments

Could you share the configuration of how you currently have it set-up?

Here is the configuration:

Sorry should have been more specific. Could you share the configs of the row/column rule(s) causing the issue?

I hope this is what you are talking about, sorry I am a new user and I am just getting my head wrapped around some of the terminology.

When I do this for the rule:

It will change other rows, not just the bottom row (which I just want the bottom row to be adjusted)

Here is what I get:

I see, I think the confusion is that there is a row labeled total and a column named total.

Try changing the configuration to be a formula like this:

IF [Account Group] = "Total" and [Total] = 0

I am getting this error message, any tips?

Thank you for all your help!

@hoye sorry try removing the 'IF'

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703