Conditional formatting

[Mar53]

I have static dates in one column, and due dates in the next column (i.e. with the formula =EDATE(A1,12) to populate a due date 12 months from the static date. Is there a way to have Excel change the due date to red font once the due date is in the past? The command/option: "Conditional Formatting > Highlight Cell Rules > A Date Occurring..." doesn't allow for this, so was wondering if the above formula could have another formula imbedded to make this happen.

 

[Paella1]

Check this out:
Excel Conditional format a due date

 

[Mar53]

Thank you! That worked.