I am trying to color the series in my graph based on conditionally formatted
cells
is this possible?

i have managed to automatically changed the color of my series in the graph,
but this doesn't seem to work on conditionally formatted cell

a little help??