Color rule a column based of another column? Color rule for text?

verytiredgirl

I have a table card with these columns: Account Name, MTD, MTD Budget

I want to apply color rule to MTD column so that when MTD is below 10% of the budget, color that MTD number red, else green. So in this example, 100 would be red, and 500 would be green.

Account Name	MTD	MTD Budget
Sales	1000	2000
Expenses	500	400

Is it possible to do in DOMO?

ArborRose

One way would be to use an html table.

with a formula like

CASE

  WHEN `MTD` < (`MTD Budget` * 0.10) THEN

    CONCAT('<span style="color:red;">', `MTD`, '</span>')

  ELSE

    CONCAT('<span style="color:green;">', `MTD`, '</span>')

END

DavidChurchman

This is something that comes up in the forum all the time, and I've seen multiple ideas posted about it. Posting it again will probably help, but also comment/upvote these. These were just the ones I could find with a quick search. If there are others, please add them in the comments

https://community-forums.domo.com/main/discussion/59462/create-conditional-coloring-based-on-a-value-not-displayed-in-card

https://community-forums.domo.com/main/discussion/66625/column-level-color-rules-based-on-multiple-statements