Highlighting total rows in pivot table

[jim37055]

Does anyone know how to have the total rows in a pivot table highlight
in a different color? I am sure there is a very simple answer here,
but I am just not finding where to do it.

 

[topola]

Put your pointer left to the Point where the Total starts. You should
get black arrow pointing to the right. By clicking now you can select
totals. Change the color. Done.

 

[jim37055]

I know how to do that... What I am looking for is a way to set up the
pivot table so that all the subtotal rows automatilly are highlighted
in a different color.

 

[topola]

That's what I have in mind. You should have all the subtotals changed
this way.

 

[Guest]

Hi

You could conditionally format the sheet before you create your pivot table.
If you click the select all box (top right of the sheet) and use Formula Is
along with:
=ISNUMBER(FIND("Total",$A1))
and select your format.

Andy.