Multiple Color Gantt Chart

[Liquid Puzzle]

I have made a gantt chart using conditional formatting, with the "AND" formula. I wanting to make a different color for different criteria. Example(s):

1. A Gantt style worksheet with 3 colors, 1 for each shift: A1 Red Shift, A2 White Shift, A3 Blue Shift.

2. A Gantt style worksheet with 3 colors, used on every row, with 3 different criteria: A1 Walk-Red, Wait-Yellow, Work-Green.

Any help would be greatly appreciated.

 

[Akashwani]

Hi,

Welcome to MrExcel.

Take a look here
http://www.youtube.com/user/ExcelIsFun#g/u
and type gantt into the search box to see if Mike has some relevant videos that may help you.

You may also want to post some sample data so that people can see what your worksheet looks like before and after you have applied the Conditional Formatting.

Good luck.

Ak