Card with conditional column comparing dynamic numbers

Question

I would lilke to create a card with conditional formating that compares two dynamic columns in seprate tables,&nbsp; Column1 calculates "days until funds must be spent", column 2 calculates "current pace to spend funds". I would like to create a card with conditional formating that makes the background of column 2 red if the value is higherbthan column1 and makes it green if the value is lower than column1. Both values will change everday. I think I might be able to use card with states but I dont how to compare the two dynamic columns. I only see the option to compare to a static number.&nbsp; Any one have any suggestions?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLE 1Contribution Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Days until funds must be spentContribution 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 775Contribution 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 887&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLE2Contribution Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Current Pace to Spend FundsContribution 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 733Contribution 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 917&nbsp;&nbsp;&nbsp;&nbsp;

dax · Accepted Answer

Hi&nbsp;dw700d&nbsp;,&nbsp;
I think you could set conditional formatting in table directly, you could refer to my sample for details.

Best Regards,Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Card with conditional column comparing dynamic numbers

2 Replies

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

Related content

dynamic conditional formatting

Compare Dynamic Columns in a Matrix

Dynamical conditional formatting for multiple columns

Dynamic Filter

Dynamic RLS

Contribution Type	Days until funds must be spent
Contribution 1	775
Contribution 2	887

Contribution Type	Current Pace to Spend Funds
Contribution 1	733
Contribution 2	917