Forum Discussion
Conditional Formatting gantt which has a weekly column header
Hi, I have a gantt chart which I've set to conditional format cells which have a start and end date. The time range for the gantt is set up weekly. However, if a milestone or activity is less than...
Hi Iain_KNox
it's probably a question of how the conditional formatting rules are set up. If you could upload an example file, it would be easier to propose a solution.
Martin_Weiss I've uploaded the file. Let me know what you think.
Hi Iain_KNox
I have changed the formatting rule for the milestone
From:
=AND(N$3>=$I4,N$3<=$J4,$D4="milestone")
Into:
=AND(N$3<=$I4,O$3>$J4,$D4="milestone")
I have uploaded the changed file, please check there if it fits your needs.
Martin_Weiss Thanks so much. I've now added a another conditional to format the Gantt grey based on the % complete.
Do you know if there is a way I can use the Milestone symbol (Wingdings) in cell D1 for the milestone in the gantt, rather than formatting the cell red?
Hi Iain_KNox
the only way I can think of is to put that symbol in every cell of the project plan and make it invisible as a default (user defined number format ;;;)
And then change the formatting rule to make the symbol visible once the conditions are met.
I have attached my example.
