Gantt & Tracker help

Good afternoon,

I have build the attached task tracker but need to amend it so instead of "start date" it reads "delivery date" (Column D)

Currently I have built the spread sheet so that the user

1)user selects task (column B),

2)the No of days to complete task (Column E) auto populates based on the task selected

3)the user adds the start date of task (column D)

4), then the cells in the timetable auto fill with the colour assigned to each task(column B) and based on the start date (ColumnD) plus No of Days (Column E).

I need to change it so the instead of "start date" it will be "delivery date" and instead of the days being added to the start date they are subtracted. Effectively the inverse of what it is doing currently

I have been looking at it for ages and cannot manage.

Any help would be appreciated!

your conditional formats are along the lines of
=AND($B8="Post Launch",G$5>=$D8,G$5<=$D8+$E8-1)

If D is delivery date
=AND($B8="Post Launch",G$5>=$D8-e8+1,G$5<=$D8)

you need to change all the conditional formats but they all follow a similar pattern

Great, thanks for the response, I changed all the conditional formulas but nothing is populating. Any thought?

Correction only the cells in the "1st April" Column fill

Your conditional formats are very similar to the formulas in column A. navigate on your ribbon at the top

home_conditional formatting_manage rules and make the changes there

does that help

I made the ammendments originally as per the above, it is only highlighting one cell in the table. Any thoughts?

Thanks for this

Yes I missed a $
=AND($B8="Post Launch",G$5>=$D8-e8+1,G$5<=$D8)
to
=AND($B8="Post Launch",G$5>=$D8-$e8+1,G$5<=$D8)

Davsth,

Thank you very much for taking the time to resolve that. Made my day considerably better!

Cheers!