Dynamically format specific axis value in a chart|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hello -

I have a chart that shows dates along the horizontal axis. There are always 28 dates on the chart, and the dates change based on table values. There are four "special dates" that I'd like to draw attention to.

1. The First Date (this will always be the leftmost/earliest date on the axis)
2. The Last Date (this will always be the rightmost/latest date on the axis)
3. The Deadline (this could be any of the dates)
4. The Forecasted Completion Date (this could be any of the dates)

I have figured out how to dynamically add text to these 4 axis values (e.g., instead of "04/26/2022" the date would appear as "** 04/26/2022 **"). However, what I'd like to do is color code each of these four axis values differently. For example:
 

1. The First Date: Dark Blue
2. The Last Date: Dark Blue
3. The Deadline: Dark Orange
4. The Forecasted: Green if earlier than deadline (which I can figure out) or Red if later than deadline (which I can figure out)

Many thanks!