If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.