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.