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



Best Answer

  • Jaketh13



    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.


This discussion has been closed.