I want to apply different formatting to the Data within my pivot table. Within RNG I want to isolate each entry, including the spaces after it, see attached.
For PLAN A, I would want to activate G5:G6, then do something IF/ELSE, etc., Then go to next value - PLAN B, activating G7:G8, PLAN C, G9:G12, through to the end of RNG.
Would I loop through the cells with end(x1up), then go down a cell - end(x1up) and so on?
Thank you in advance,