I have a standard generic Excel Gantt chart that works perfectly fine that I would like to show different colored bars based on a name in one of the cells. Can anyone help.
A1, B1, C1,
xx, 8/1/2011, 8/15/2011
yy, 8/2/2011, 8/10/2011
If xx then show red bar, if yy then show blue bar...