Pivot Table

Lara
Lara
in Card Building

Is there a way to do conditional formating based on another column directly in pivot table?

 

Example: color in green if value in column A > then in column B

 

Thanks 

Best Answer

  • Jaketh13
    Jaketh13

    domo

    💎
    Answer ✓

    Hey @Lara,

     

    It's not currently possible to set color rules of off the two columns you're comparing. The column the conditional formatting is applied to needs to be a static value in the visualisation as well. You could create a column that gives the difference or even just flags the rows where column A > column B and set a rule off of that column.


    Thanks,
    Jake
    **Say "Thanks" by clicking the "heart" in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Answers

This discussion has been closed.

Categories