Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Highlighting(coloring) totals in a pivot table
Hello All,
I have a pivot table which is regularly refreshed. I want the totals (which are in this case only in column A) to be highlighted. Is there a way to do this? I have tried some vba but to no avail. (for your info the totals in column A of the pivot lokk like "Energy Total" , "Gas Total" , etc) Thanks for any tip. |
#2
|
|||
|
|||
CTR-A
Format / Conditional formatting - Change 'Cell value is' to 'formula is' and put in =RIGHT($A1,5)="Total" Hit the format button, set your format and you are done. Now, you may prefer to select anhy one of the totals rows by hovering the cursor just to the left of it, and left clicking. this should highlight ALL the totals rows - set your format and it should be remembered when you refersh, as well as be applied to any new totals values in your fields. Personally I would go for the latter. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Ludavhen" wrote in message . nl... Hello All, I have a pivot table which is regularly refreshed. I want the totals (which are in this case only in column A) to be highlighted. Is there a way to do this? I have tried some vba but to no avail. (for your info the totals in column A of the pivot lokk like "Energy Total" , "Gas Total" , etc) Thanks for any tip. |
#3
|
|||
|
|||
Ken, many thanks !
Option 2 was exactly what I was looking for ! And option 1 is definetly a helper I might in the future use. regards. "Ken Wright" schreef in bericht ... CTR-A Format / Conditional formatting - Change 'Cell value is' to 'formula is' and put in =RIGHT($A1,5)="Total" Hit the format button, set your format and you are done. Now, you may prefer to select anhy one of the totals rows by hovering the cursor just to the left of it, and left clicking. this should highlight ALL the totals rows - set your format and it should be remembered when you refersh, as well as be applied to any new totals values in your fields. Personally I would go for the latter. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Ludavhen" wrote in message . nl... Hello All, I have a pivot table which is regularly refreshed. I want the totals (which are in this case only in column A) to be highlighted. Is there a way to do this? I have tried some vba but to no avail. (for your info the totals in column A of the pivot lokk like "Energy Total" , "Gas Total" , etc) Thanks for any tip. |
#4
|
|||
|
|||
You're welcome :-)
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Ludavhen" wrote in message l... Ken, many thanks ! Option 2 was exactly what I was looking for ! And option 1 is definetly a helper I might in the future use. regards. "Ken Wright" schreef in bericht ... CTR-A Format / Conditional formatting - Change 'Cell value is' to 'formula is' and put in =RIGHT($A1,5)="Total" Hit the format button, set your format and you are done. Now, you may prefer to select anhy one of the totals rows by hovering the cursor just to the left of it, and left clicking. this should highlight ALL the totals rows - set your format and it should be remembered when you refersh, as well as be applied to any new totals values in your fields. Personally I would go for the latter. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 -------------------------------------------------------------------------- -- It's easier to beg forgiveness than ask permission :-) -------------------------------------------------------------------------- -- "Ludavhen" wrote in message . nl... Hello All, I have a pivot table which is regularly refreshed. I want the totals (which are in this case only in column A) to be highlighted. Is there a way to do this? I have tried some vba but to no avail. (for your info the totals in column A of the pivot lokk like "Energy Total" , "Gas Total" , etc) Thanks for any tip. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
Pivot Table services | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |