Pivot Table

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

    💎

    Accepted 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.

Answers

This discussion has been closed.