Conditional formatting based on multiple columns

saket
saket Member
in Cards, Dashboards, Stories

I want to compare two columns and their values in a card.

I have column A and B. I want to apply color rules on the lower value cell between the two cells.

I know you can set the color rules based on individual columns. I know you can create a beast mode and set a flag for the conditions. I currently have the color rules applied on the row, but the user only wants it to apply to the cell on each row.

Is there any other solution to accomplish this specific use case?

Thanks,
Saket

Tagged:

Best Answer

  • ArborRose
    ArborRose Coach
    Answer ✓

    Applying color rules at the cell level based on the comparison of two columns directly is not directly supported. As you mentioned, you can try to create a beast mode calculation that compares the values of columns A and B and sets a flag accordingly. Then, apply color rules based on the flag.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • ArborRose
    ArborRose Coach
    Answer ✓

    Applying color rules at the cell level based on the comparison of two columns directly is not directly supported. As you mentioned, you can try to create a beast mode calculation that compares the values of columns A and B and sets a flag accordingly. Then, apply color rules based on the flag.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Categories