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.

Next, we’ll use a conditional formatting rule to format a cell, based on the combo’ selected value. I’m using (desktop) Office 365 but you can use earlier versions.

In that article, "Use Excel's conditional formatting to highlight weekends," we created the sheet shown in Figure A. By separating the year, month, and day, you can reuse the same sheet. This ...