| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
[VBA] How to highlight rows in PivotTable
Hi,
I have PivotTable in Excel 2003. In "Row Fields" there is dimension called [DepartmentEmployeeProject] which consists of [Department], [Employee] and [Project] levels. In "Page Field" there is dimension called [ProjectTypes] which consists of one [Types] level. The "Page Field" [ProjectTypes] has two items: "closed" and "opened". When all the items in "Page Field" have been chosen I would like to obtain highlighted rows that refer to closed projects. What code should I use to get this effect. Thanks for any help. -- TM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| [VBA] How to highlight rows in PivotTable | Excel Worksheet Functions | |||
| [VBA] Hiding rows in PivotTable | Excel Discussion (Misc queries) | |||
| [VBA] Hiding rows in PivotTable | Excel Worksheet Functions | |||
| Count rows in a PivotTable | Excel Programming | |||
| Sum Distinct Rows in PivotTable | Charts and Charting in Excel | |||
Linear Mode
