Conditional formatting in a Gantt chart?

[Blueseashell3]

Hi all,

I'm trying to make a fancy automated Gantt chart type thing for my team to use for keeping track of our projects without having to fill in the cells by hand. I have it mostly covered, however my main last snag is that I want to be able to do some manual formatting on the cells that will override the conditional formatting (without removing the formatting first). For example, I'd like to (if a due date shifts becuase of delays or whatnot) put a thick border of some color around the cell of the original due date in the Gantt's bar.

I was also asked to add a functionality where you can change the color of a previously 'on-track' task to yellow or red on+after the date where it went off the rails, which would be nice; I can't even begin to imagine how I might format that conditional rule without having to add a few extra columns, which would make it unwieldy. If anyone might have a solution here that would be really helpful too!

-Blueseashell3

 

[Minilin]

Hi all,

I'm trying to make a fancy automated Gantt chart type thing for my team to use for keeping track of our projects without having to fill in the cells by hand. I have it mostly covered, however my main last snag is that I want to be able to do some manual formatting on the cells that will override the conditional formatting (without removing the formatting first). For example, I'd like to (if a due date shifts becuase of delays or whatnot) put a thick border of some color around the cell of the original due date in the Gantt's bar.

I was also asked to add a functionality where you can change the color of a previously 'on-track' task to yellow or red on+after the date where it went off the rails, which would be nice; I can't even begin to imagine how I might format that conditional rule without having to add a few extra columns, which would make it unwieldy. If anyone might have a solution here that would be really helpful too!

-Blueseashell3

Have you got a screenshot of what you have already done. Trying to picture how you have set it up might help get you a solution.