I have a subtotal row at the top of a pivot table with numbers,
currency, and percentage which match the proper format of the
information in the same column in the pivot table below. When I add a
row field, the pivot table expands by one column and my subtotal row at
the top is off on it proper format by one column. I am asking two
questions: 1) is there a way to conditionally format a cell to match
the format of another cell or range? and 2) is there a way to have a
pivot table display the grand total at the top instead of the bottom?
Question 2 would be interesting and a better way to handle this. But I
would continue to be interested in the answer to the other for other
potential uses. Thanks.


--
bakes1
------------------------------------------------------------------------
bakes1's Profile: http://www.excelforum.com/member.php...o&userid=31965
View this thread: http://www.excelforum.com/showthread...hreadid=516913