Is there a way to do the following thing in excel. Say I have some data in the spreadsheet. Eg numbers . Some of them are highlighted due to certain reasons and such. These are put into a graph. Is there a way so that the graph has the same coloured bars than the highlighted cells?
So in other words the graph bars will be at least 2 different colours depending on if the data is highlighted or not?