Share via

Adding columns to template Gantt chart and retain conditional formatting

Anonymous
2022-02-15T06:14:16+00:00

Hi, I need to add additional columns to a template Excel gantt timing plan. I can't figure out how to carry over the conditional formatting so the planned and actual functions carry over to the new columns.

I need to ensure the planned and actual formatting is carried over to the new columns because I need more than the 60 periods in the standard template.

I don't have experience with MS Project so I don't really want to have to learn that, and re-create this gantt chart in MS Project.

Thanks in advance

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2022-02-15T21:44:32+00:00

    Hi George,

    Thanks for your response.

    I have figured it out now thank you.

    I am using the MS Excel template Gantt chart as shown below.

    All I needed to do was continue the period numbering and the conditional formatting copied along the extended area I needed.

    Thanks again

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-02-15T20:45:11+00:00

    Hi Jon,

    Thanks for posting in the community.

    According to your description, may I know which Excel template you are using? Please provide the template name for us to better test.

    Regards,

    George

    0 comments
  2. Anonymous
    2022-02-18T06:33:27+00:00

    Dear Jon,

    Thanks for your updates and sharing the suggestions here.

    I'm glad to hear that the issue has been solved by yourself.

    Welcome to post a new thread on our forum at your convenience if you encounter any issues.

    Have a nice day!

    Cliff

    0 comments