| 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| [VBA] Hiding rows in PivotTable | Excel Discussion (Misc queries) | |||
| Hiding rows while sheet is protected | Excel Discussion (Misc queries) | |||
| Highlight entire rows as I scroll? | Excel Discussion (Misc queries) | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| How to highlight alternate rows | New Users to Excel | |||
Threaded Mode
