How to utilize name manager

[jt0080]

I recently downloaded a template from office.microsoft for a GANTT chart.

This chart seems to utilize dynamic cell selection to change the values that are withheld in the name manager. These new values are used as conditional formatting to change the color and placement of color within a cell over a specified range.

I am very curious about how to re-create this document as the tools used can be extremely useful in many applications but I cannot seem to figure out how to do it.

The excel document can be found here. Gantt project planner - Templates

Thank you in advance.

 

[skywriter]

I am very curious about how to re-create this document as the tools used can be extremely useful in many applications but I cannot seem to figure out how to do it.

If it's an Excel file I'm not sure of your request.
Why not make a copy of it and reuse whenever needed?

 

[jt0080]

If it's an Excel file I'm not sure of your request.
Why not make a copy of it and reuse whenever needed?

I would like to be able to create it myself so I could utilize the methods in other applications