Applying a PivotTable style

When you create a PivotTable, Excel applies some basic formatting so you can…easily distinguish with the labels and organizational layers from the data in…the body of the PivotTable.…Excel does come with a substantial number of built-in styles from which to…choose, so if you do want to change your PivotTable's formatting you can do so easily.…Before I get into styles I do want to point out that you can format…individual cells within a PivotTable and have that formatting stay with us…when you pivot the table.…So for example let's say that I wanted to highlight the value 130 that is…currently in cell C6 and I will do that just by applying a yellow fill color to that cell.…

When I pivot the PivotTable, that yellow formatting will go along with that cell.…So let's say that I put Company on top of the Row Labels area and when I do,…the formatting has stayed with the cell that contains the value 130 and I just…scroll down using my mouse wheel to display it.…Then if I put Company back in the Column Labels area and scroll back up, then…