Make gantt chart using conditional formatting

There are many which shows you complex ways of creating Gantt chart. The following shows how to create a Gantt chart in just 5 mins. Why you want to waste an hour when you can create it in minutes.

Please create Task Name, Start Date and End Date for your activities. Add the month date as shown below in the image.

Now select all the dates. In above case from D2 to H5 and select conditional formatting formulae based.

Write the formulae as shown above and also select the format in which you want to highlight the cells. Please note thet I have used $ in some cases to make it fixed. I have made B and C columns as fixed however i not made their row numbers as fixed. Once you click OK your Gantt Chart will be shown as below.