Click OK to return to the sheet. Figure F This conditional format will highlight the subtotaling rows. Currently, the data set contains no formulas in column C so there’s no formatting.

To add this new rule, do the following: Select B4:D8. On the Home tab, click Conditional Formatting in the Styles group. From the dropdown, choose New Rule.

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.