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



    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.

    **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"


This discussion has been closed.