Highlighting total rows in pivot table

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.

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.
--
topola, http://vba.blog.onet.pl

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.

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

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.
"jim37055" <jim37055.2034em_1134655800.9907@excelforum-nospam.com> wrote in
message news:jim37055.2034em_1134655800.9907@excelforum-nospam.com...
>
> 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.
>
>
> --
> jim37055
> ------------------------------------------------------------------------
> jim37055's Profile:
> http://www.excelforum.com/member.php...o&userid=27788
> View this thread: http://www.excelforum.com/showthread...hreadid=493778
>