Forum Discussion
Conditional Formatting gantt which has a weekly column header
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.
- Thanks Martin, really appreciate this.
Martin_Weiss Looking at row 8,9 in attached I've come across an issue. If the activity is only for that day or for 1 day, the gantt does not populate. It only populates once the duration is 3 days which takes the end date to 19 Sept. Is there a way to add some logic to the conditional format to still populate the gantt when the start-end date is between 2 dates in the column?
- Martin Weiss I think I have fixed it, I needed to update the conditional formatting for L1-L3.
