Grantt Progress Bar

[E5254730]

Hi All,

See attached excel for your reference.

I'm looking to show a progress bar in the Grantt template

For E.g. I have a task as "Pull Data", which is expected to end on Oct 19, 2022. So I want a condition / formula which will highlight the cells till Oct 19th.

Similarly - "Send for Review" task in getting end on Oct 12th, 2022, so it should get highlighted till Oct 12th.

Also, is there a way we can show a Progress bar in % with Green color, under each task.

Thank you for your help in advance.