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.

Each accepts up to 255 values in a comma-delimited list enclosed in parentheses and preceded by the name of the function. You can mix cell references and numbers, including null and zero values.