Trying to figure out how to change bar graph colors based on the color of cells. In older excel versions there was a button that said "apply cell colors from spreadsheet". The cells are colored from conditional formatting if that matters.
I am not aware of such an option and I've been using Excel since 1996. That being said, if you need conditional colors for a bar chart, the way to implement that is to have a separate column of data for each condition which contains either a value when the condition is met, or #N/A when not. A bit complicated to explain, Jon Peltier does a pretty good job here: https://peltiertech.com/conditional-formatting-of-excel-charts/