After I have made this selection, the PivotTable will now show the conditional formatting in all cells showing sales for an individual product category and an individual year.