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
Solved! Go to Solution.
Here is the configuration:
Hi @hoye
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:
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
I am getting this error message, any tips?
Thank you for all your help!
@hoye sorry try removing the 'IF'
@hoye , Don't think you need the 'IF' here, just try [Account Group]='Total' and [Total]=0