# 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

- 11K All Categories
- 5 Private Company Board
- 2 APAC User Group
- 12 Welcome
- 42 Domo News
- 9.9K Using Domo
- 2K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 349 Workbench
- 266 Domo Best Practices
- 11 Domo Certification
- 474 Domo Developer
- 51 Domo Everywhere
- 110 Apps
- 725 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 28 お知らせ
- 65 Kowaza
- 301 仲間に相談
- 662 ひらめき共有