# Dynamic Conditional Format - Sumo Card

I'd like to be able to write conditional formatting rules in a sumo card beyond just a hard-coded number. For example, use the number in the 'total' row for a given column, rather than typing in a static value.

Here's an example of when I would need this. If I have a calculated field (Cost per click, for instance) in my sumo card, then the total will not necessarily be a "sum" total of the numbers above it - rather it will be a calculation of another sum totaled column (cost) divided by another sum totaled column (clicks). So - some cost per click values will be greater than the total, and some will be less than the total. I'd like to be able to place conditional formatting rules on that column that look at the number in the 'Total' row, rather than a hard-coded number. For example, if less than the total, highlight in green, if greater than the total, highlight in red. Since my cost per click is changing every hour, the conditional format needs to be dynamic.

Thank you for your consideration!

## Comments

#### Categories

- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 338 Workbench
- 250 Domo Best Practices
- 11 Domo Certification
- 460 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 295 仲間に相談
- 649 ひらめき共有