I have a small table of values like this:
Food Count Color Pumpkin 345 #DB3236 Cabbage 193 ? Pepper 89 ? Beetroot 96 ? Potato 62 ? Lettuce 35 ? Carrot 26 ? Tomato 25 ? Banana 22 ? Apple 22 #FADBDB
I want to calculate a color gradient between #DB3236 and #FADBDB based on the COUNT values.
For example "Pumpkin" = 345 and has the strongest color, and "Apple" = 22 which is the weakest color. Even though "Potato" is in the middle of my table it only has a Count value of 62 which means it will be quite weak on the color gradient scale.
I'm not great with numbers so I'm really struggling how to figure this out.
How do I create the color gradient for the other foods on my table?