Colour cells of pivot table If value greater than 0

[001NewGuy]

Ian trying to develop a pivot table to show who has completed certain training I want to color the cells green that have a value What’s the best and simplistic way to do this Thank you

[nicolaskruchten]

This example https://pivottable.js.org/examples/montreal_2014.html has a custom color scale, which is what I would use in this case.

[001NewGuy]

Thanks for the feedback, one other thing I am developing a pivot table based on the Pivot Demo From Local CSV sample

is there a way to have the heatmap as the default when the pivot table loads\ thank you