Conditionally format a Gantt chart using an Excel bar chart

[BrianCurran]

Hi,
I've created a Gantt chart using an Excel bar chart and would like to be able to conditionally format it if possible.

The cells in the "Duration" column are conditionally formatted Red, Black or Green depending on whether they are Evenings, Nights or Mornings "Shifts".

What I would like to do is replace the Blue bars on the chart with these colours, is that possible?

Many thanks
Brian.

 

[Steve=True]

This link has the principal concept you are trying to obtain.

Should do what you are looking at doing:


How-to Make a Conditional Column Chart in Excel
http://www.exceldashboardtemplates.com/?p=891



Good luck!

 

[BrianCurran]

Excellent tutorial, many many thanks...

 

[Steve=True]

Many Thanks Brian for the kind words.

Glad the tutorial worked for you.