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.

Office expert Susan Harkins teaches you two ways to highlight the lowest and highest values in an Excel row or column.