Results 1 to 2 of 2
2005-05-04, 12:44 #1
- Join Date
- Mar 2004
- North Carolina, USA
- Thanked 0 Times in 0 Posts
Highlight word Total in Pivot Table (2003)
I am using a pivot table and would like to highlight the word "Total" each time it is encountered in a specific column.
Is this possible?
2005-05-04, 14:23 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- Thanked 342 Times in 335 Posts
Re: Highlight word Total in Pivot Table (2003)
If you want to highlight cells that equal "total" or that contain "total" you can do it with conditional formatting (you will have to redo the cond formatting after the pivot is refreshed). I know it is not "saved" with the formatting in XL97 (perhaps it can be preserved in later versions). You could create a macro to refresh and then reformat the pivot if desired.
If you only want to hightlight only the word Total that is contained in a cell, you will have to use a macro to find the cells containing Total and then highlight just the word.
If you need additional info please post back with more details on what is desired/needed. If a macro is needed the pivot table name and the sheetname with the pivot is needed...