Conditional formatting to change Bar graph colour

[jpaulbiss]

I am using conditional formatting to highlight value ranges in a spreadsheet. Is it possible reflect these colours in the accompanying bar chart?

[Zizi64]

Just a tip:
Use conditionally filled-in columns as a Data Range for the Bar Graph.

[mariosv]

Maybe

how set colors for color and fill in charts

In the Chart Wizard, we can enter ranges for color and fill for each data series. The problem is that I don’t know what to put in the cells. Presumably the cells could contain numeric codes for colors. That way, each data point could have its own color. But what codes are used? How do I find/derive them? Also, I have read about property mapping and it sounds like it could be used. In fact, it looks like there used to be a button for property mapping. However, there is such button now. If I wan…

can help.