There's a lot going on in these formulaic conditional rules in Microsoft Excel that highlight the smallest and largest values within a period of years.

This is the demonstration file to accompany the article, How to find the minimum and maximum values within a specified set of years in Excel, by Susan Harkins.