Forum Discussion

Sreebalajinarayanan's avatar
Sreebalajinarayanan
Copper Contributor
Mar 31, 2024

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?

Resources