Sparkline (column) colour

[sjoerd.bosch]

Hello.
Is there a way to force a colour to a sparkline (column) instead of having to change it manually?
I am looking to assign a specific colour for different products in the same Sparkline column.
If I have a product - let's say "A" - I want the column to show red - if "B" - Blue - if "C" green - if "D" orange - if "E" - yellow
The data has to come from specific cell as reference for the data. The input data is from 0 - 100%
Many thanks in advance.

 

[sjoerd.bosch]

Alternatively - I could use a VBA code if it behaves similar to a sparkline column
So, the colour has to grow/shrink with the percentage input in the one cell (or range of cells vertically in a column)
and colours changing to my choice of product

 

[Fluff]

Duplicate to: Filling cells partially (based on percentage) and any colour of my choice

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.