Text colour change on report for non compliant dates

[Alex]

I am working on a training database and deal with courses that are compliant
for 1 or 2 years. In a report I would like to use conditional formating to
change the dates text from black to red if they are more than 2 years before
current date. how would I do this.

 

[Allen Browne]

Select the text box in report design, and choose Conditional formatting on
the Format menu.

Choose:
Less Than ... DateAdd("yyyy", -2, Date())
and apply the formatting you want.