Dynamic colour to a table based on increases/decreases in data

[Anonymous]

I am trying to create a table that emulates the Tableau predecessor below:

I'm particularly struggling with the green/red colouring to show whether there has been an increase or descrease in the data since last refresh.

Does anyone know how I can do this?

Many thanks.

[bhanu_gautam · Accepted solution]

@Anonymous , There is one article, I think it will be helpful for you

https://www.esbrina-ba.com/conditional-formatting-with-a-dynamic-divergent-color-gradient-for-values-and-totals/

[Anonymous]

Thank you!