Indication for missed milestone when milestone is defined by dependency

I have a series of activities that are meant to be constrained by two milestones. The first milestone is a fixed date and the second milestone is a floating milestone set with a dependency delay of 5 days after the first milestone.

How can I have an indication when the planned work for these activities exceeds the date of the second milestone? The parent activity (dark green in attached screenshot) has the second milestone set as a Target Milestone, and all the other activities are set as children of this parent. My goal is to have the parent activity show up as red in the Gantt chart when it exceeds the planned date of the target milestone.

We shouldn't have to if the milestone knows which date it is planned on. This would make it a huge exercise as we have 20+ projects with around 50 milestones each. Any time we miss a milestone or add/remove resources we would then have to manually shift all the milestones which defeats the purpose of planning by dependency.

I'm not sure how to set up the dependencies in your example. If I make the second milestone the successor to the parent activity, then it just pushes the milestone forward as more work builds up. It does not respect the delay set in the dependency between the first and second mielstones (which should be correct behaviour, as the delay is meant to represent a minimum value). I need the milestones to stay where the delay places them, but the activities to highlight if they are going to miss a target milestone.

So, for example, I have Milestone #1 set to Monday and Milestone #2 set to Wednesday using a 2-day delay. Between them is an activity set to begin with Milestone #1 as the Predecessor, and Milestone #2 is set as the Target Milestone. I want Milestone #1 and #2 to stay set in place based on delays set in my dependencies. If the activity is assigned, for example, 6 days of work, it should overshoot Milestone #2 and turn red, with Milestone #2 remaining on Wednesday unless I manually change the dependency delay.

Could you provide a way to set up milestones and activities to show what is in my example above?