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 1 week and doesn't start on the week commencing date it doesn't populate. I don't won't to set up the gantt with each day as the column header. Would really appreciate some help as I've tried various options but no success.
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.
