Hi: I am trying to set up a template that tracks the courses taken by employee's across the top, the employee's names along the side, and the course (expiration) dates of each course in the worksheet. Each course has a different expiration period (most are 3 years, some are indefinite, some are two years). The template that I saw, the course date turned yellow if the expiration date was within 3 months, and red if it was within one month.

Anyone know how this is done?

All help will be appreciated.