Looking to create a gantt chart in excel basis a start and end date range

[Vaibhav002]

Hi,

I have a work plan to create for which I have the activities listed in rows while the date range (start and end date against it). I want to basically colour code the cells basis the data range.

I have attached a sample input vs output in the file.Please help me with this.

Thanks!

[#2]

@Vaibhav002 

Select I5:T6. I5 should be the active cell in the selection.

On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula

=AND(I$4>=$E5,I$4<=$F5)

Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.

See the attached version.