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.
No comments:
Post a Comment