Figure E Subtotal adds a function to the subtotaling row. Before you can set the conditional format, remove the subtotaling rows by clicking Subtotal (Data tab) and clicking Remove All.

Learn how to use Excel's Subtotal feature to quickly add summarizing rows to your data.

Excel's Subtotal command allows you to quickly create subtotals in your sorted data, and then collapse the view to to show only the new subtotal rows.