Hello, I'm trying to use VBA to conditionally format a pivot table with multiple different Row Labels. Making the issue more complex is that the Pivot Table is created from another macro and often results in differing ranges so they can be dynamic and not always contain the same Row Labels. Using the macro recorder, I am able to get the conditional formatting recorded; however, I lack the knowledge to implement it on dynamic ranges rather than fixed ranges. If anybody could help, it would be greatly appreciated.
Highlighting of the entire row or any other indication would work fine – not just the time as shown in the example.
Example2.jpg
CVinje
Bookmarks