Conditional Formating Chart Points

[BKGLTS]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Item1
[/TD]
[TD]-2
[/TD]
[TD]Station25
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Item2
[/TD]
[TD]-5
[/TD]
[TD]Station26
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Item3
[/TD]
[TD]-7
[/TD]
[TD]Station27
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Item1
[/TD]
[TD]-8
[/TD]
[TD]Station28
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]Item3
[/TD]
[TD]-10
[/TD]
[TD]Station29
[/TD]
[/TR]
</tbody>[/TABLE]
Hello,

I need help please.
I have been searching the internet and cannot find this solution.
Column B is plotted on a chart as points.
I need the Item1 points to be Yellow, Item2 points Blue, Item3 points Red.
The list must be in a mixed order shown and cannot be sorted.
Column C is the Horizontal Axis.
The Vertical Axis is a scale for the Column B numbers.

Thank you,
B

 

[BKGLTS]

Here is an example of what I am trying to achieve.
The conditional colors need to be dynamic so as the data changes the colors change with it.
Colors cant be hard coded.