# Can I show positive (instead of negative) numbers in red?

Member

I have a table that shows YoY comps as a percentage for four different metrics. For three of the metrics, negative is bad and positive is good. For the fourth metric, negative is good and positive is bad. I found the option to "Show Negative Numbers in Red", which works correctly for three of the rows but not the fourth.

Is there a way for me to have only one row be opposite of normal with positive numbers in red?

Tagged:

• Coach

@Alex_K You can do this by adding HTML to your metric in a beast mode like this:

```case
when `Sales` > 0 then concat('<div style="color: #f00">',`Sales`,'</div>')
else concat(`Sales`,'')
end
```

Here is a knowledge base article on how that works:

• Contributor

@Alex_K Hey there! Have you tried this?

IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!

• Coach

You can actually use color rules to do this and not lose the formatting you are applying to the cell. Create a color rule, select a color and set the opacity to zero, then select the table text to be the text choice in the middle and unselect the apply format to table row.

**Check out my Domo Tips & Tricks Videos

**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.

• Coach

Have you looked into utilizing color rules so that if it's < 0 it's green and > 0 it's red?

**Did this solve your problem? Accept it as a solution!**
• Coach

@Alex_K You can do this by adding HTML to your metric in a beast mode like this:

```case
when `Sales` > 0 then concat('<div style="color: #f00">',`Sales`,'</div>')
else concat(`Sales`,'')
end
```

Here is a knowledge base article on how that works:

• Contributor

@Alex_K Hey there! Have you tried this?

IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!

• Coach