Forum Discussion
Conditional formatting for highlighting the dates as per the milestones
Hi all,
I'm new to this forum. I need support in conditional formatting for a Gantt chart in excel.
I have the made the below Gantt chart in excel, where when I select "Today" in Highlight dropdown list, then today's date gets highlighted in the timeline by conditional formatting.
Similarly, when I change the Highlight dropdown list option from "Today" to "Milestones". I want to Highlight all the Milestone dates in the timeline.
Can someone help me with the conditional formatting rules?
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar Thanks for your response. Pls refer the link for the sample file.
https://docs.google.com/spreadsheets/d/1cLCzsSGpeX26KjqyJiDAYlRhB9zqI1OY/edit?usp=drive_link&ouid=108877107317939531893&rtpof=true&sd=true.
As explained, I would like to highlight the end date of the milestones in the timeline when we select "Milestones" in the Highlight dropdown list. Looking forward for your comments.That workbook doesn't work because it depends on links to another workbook.
