I have a stock chart (not actually stock data, but I have a floating bar with “high” and “low” data, so it seemed to fit), and the data it’s based on has conditional formatting applied to make the cell background change colour when certain criteria are met. Both the high and low value are used to calculate the colour, and they both get the same colour.
I would like the bars in the chart to reflect that colour. I can go in and manually change the colour for each datapoint to be the right colour, but I’d rather have a way of making it happen automatically.
Is this possible?