I am no able to find out how to highlight the source data values for a value selected in my pivot table. e.g. if I select a value (say 57111.25) in my pivot table then all the values/rows in the source data whose sum is that value (57111.25) should get highlighted/colored/numbered. There is a functionality through which that data is extracted in another sheet but I want it to get highlighted in the original source data itself.
Any help would be much appreciated either through some function or VBA. Thanks in advance.
Bookmarks