I want to highlight data pertaining to a particular line in the pivot table subject to certain criteria (here sum of Reco amount = 0).
I am able to insert pivot using VBA but not able to get to the lines and highlight individual lines related to that.
Is it possible to that or is it too far fetched for VBA?
Expected output- Except for 01.08.2022 and 18.08.2022, all the lines will be highlighted in the original data table.