I have a cash projection spreadsheet with a linked line chart. In the
projection sheet, the font goes from black to green when the data goes from
actual to projected.

Is there a way to make the line or the x-axis change colors at the point
that the date does so (i.e., have the line turn green halfway through the
chart)?

Thank you in advance.