Conditional formatting based on multiple columns

saket

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

ArborRose

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.

ArborRose

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.