in a data table, fill in the background of each field with more or less intensity depending on the magnitude of the values

[vicente89]

Good morning,

I would be very grateful if someone could help me with this question:

I have a table with data, in which I would like to put 1 or 2 of those columns in green, where the intensity of the colour of each of the squares where each of the values is located would be according to the magnitude of that value.

I would like that if it is the highest value in the table, it would appear in a very intense green (the bottom of the square where the field is) and as the magnitude of the values went down, the intensity of the green colour would go down.
I attach a screenshot with the table that I would like to appear as I said and another screenshot with a couple of examples of how I would like it to look approximately.

If it is not possible to do this as I say, I would be grateful if you could give me some other alternative solution to the conditional distribution by colours to the magnitudes of the measurements in the tables.

Thank you very much.

[woutermak]

You can use a colormix function:
for example:
colormix1(rank(total Column(1))/NoOfRows(total),rgb(230, 237, 100),rgb(230, 0, 0))

here an example with out selection:

and with a selection on product a and b