Does conditional format apply to bars of a Gantt chart ?

Hey guys.

I have a chart in 'Active Projects' sheet that uses data from 'Workflow' sheet. The chart is updated as data is inserted and meets a criteria. Some fellows here in the forum suggested that I create a formula to copy data from 'Workflow' sheet to 'Active Projects' sheet so the chart retrieves data from a range of cells after applying an autofilter. It's all working fine. However, the conditional formatting isn't copied along with the data. Although I can actually make my way around this, I couldn't find a way of making the bars in the Gannt chart match the colors of the correspondent cell background.

I read a couple of articles about this and tried to create different series for each conditional format but it all went wrong and became a complete mess. Besides, all articles seem to be outdated cuz Excel does not allow me to select more than one single column per series as they suggested.

Does anyone know how to do this in Excel 2013, if possible?

Thanks.

Hey guys.

So it happens that those articles I read were right after all. I had to create one series for each condition to be met, 5 in total, each with its own color. Since it is a Gannt chart I had to create other 5 series in order to follow up with the progression of the project, all with the same color. You can finde the results in the file WORK PLAN (2).xlsm.

Hope this helps anyone around.