PivotTable - cell format
 

Hi,

I have a PivotTable with two columns - student names and tuition.

I highlighted the **grand total tuition** with fill color. Please note that
only ONE cell had this format.

However, when I changed the column of student names to a row of student
names (by moving the "button"), all the tuition (and not just the grand
total) had the fill color. Is this a bug? Is there a way to get around
this? I know I can remove the fill color first, change from column to row
then put back the fill color. Just wondering if there is a better way.

Appreciate advice.

Epinn