Conditional Formatting Dates based on Today and End Fiscal Year

I have a table of mostly dates. The first couple columns are employee identifiers (name, employee ID, Job, Department). The rest of the columns are renewable qualifications and when each one is expir...