Hightlight date cells based on expiry

so the formula you want is something like:

=EDATE(C2,D2)

this will give you the number of months in D2 after the date in C2.  This will give you the Expiration date of the course based on the date completed (C2) and the expiration duration (D2).

As for easy to see you can then either do a simple conditional formatting on that Expiration Date column like using a Red/Yellow/Green Icon Set.

or you could highlight the whole row (or any part thereof) usung a custom formula like this:

here is the custom formula entry:

notice how I highlighted the cell A2:D2 and the formula is =EDATE($C2,$D2)<TODAY()+60

the $ are important because you want excel to ALWAYS use columns C and D and NO $ before the 2 because you want excel to look at the same column as the cells it is checking.  The +60 is for 60 days after TODAY().

I also did the same formula without the +60 for the Red formatting and made sure the red rule is above the yellow rule so it will take precedence.