How to use row rule for 1 specific row?

[hoye]

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:

Thank you so much everyone has been so helpful!

-e

[Luke_C]

Hi @hoye 

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

[hoye]

Here is the configuration:

[Luke_C]

Hi @hoye 

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

[hoye]

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:

[Luke_C]

Hi @hoye 

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

[hoye]

I am getting this error message, any tips?

Thank you for all your help!

[Luke_C · Accepted solution]

 @hoye  sorry try removing the 'IF'

[FinnCharlton]

@hoye , Don't think you need the 'IF' here, just try [Account Group]='Total' and [Total]=0