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?
excel
Formulas and Functions

5 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Mar 31, 2024

    Sreebalajinarayanan 

    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?

    • Sreebalajinarayanan's avatar
      Sreebalajinarayanan
      Copper Contributor
      Mar 31, 2024

      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.

Resources