Designer| Pivot table conditional formatting

[Mj9715]

Hi All,

I have used summarize tool to create pivot tables as shown in attached file (input).  However, excel has a 3 color scale function that fills gradient color according to value of the cell. I wish to replicate a similar fill color mechanism by value of the data (depicted in output table on attached file). Please can someone guide how this can be achieved in Alteryx? 

[atcodedog05 · Accepted solution]

Hi @Mj9715 

As far i know there is no table gradient color capability in Alteryx. You can replicate the same mechanism by setting up column rule defining the value range and color for it like below.

Workflow:

Hope this helps : )