A Quick Gannt in excel

See the sample file here.


1. Open up a new excel file
2. Under column A, we would have the Task Names
3. Under column B, we would have the Start dates
4. Under column C, we would have the End dates
5. Column D onwards we have the dates for which we are building the Gantt.
6. Select cell D2 and copy this formula into the cell:
=IF(AND(D$1>=$B2,D$1<=$C2),1,0)
7. This formula essentially says, "If the date at the top of this column falls between the start and end dates, then have the value 1 in this cell; else have 0 in this cell.
8. copy the contents of the cell having the formula (Cell D2 in the example)
9. Select all the cells under the date columns (Cell D2 to AH7 in the example)
10. Paste the formula into all the selected cells
11. In the toolbar, select Format -> Conditional formatting
12. Select "Cell Value is" , "equal to" , and type the number "1" without quotes in the condition.
13. Click on Format
14. Select Patterns tab
15. Select a color of your choice (not white!!)
16. Add one more condition.
17. Perform steps 14-15 and select white this time.
18. Click OK
You're all set !! Fill in the dates and see the Gantt chart appear !