copy the pt1 worksheet to a new worksheet named pt2. notice that you are creating a copy of the entire pt1 worksheet, not just the actual pivottable! rearrange the fields in the pivottable to analyze department sales by quarter. use conditional formatting to apply a yellow fill color to the cells that represent the highest quarterly sales amount in each of the four quarters.