To highlight source data values for a value selected in pivot table

[hello_123]

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.

The above has also been posted at below link but as have not received a response since more than 20 days so posting it here too :

https://www.excelforum.com/excel-ch...lues-for-a-value-selected-in-pivot-table.html

 

[Grumpy Old DBA]

The article is posted at https://www.mrexcel.com/forum/excel-questions/190025-pivot-table-drilldown-2.html.

An abbreviated answer is:

A standard feature of pivot tables is "Show Details".
If a pivot table has PivotTable options | Data | "Enable Show Details" on then:

double click​

or​

right click | Show Details​

to copy the data behind that cell into a new detail (or drilldown) worksheet.

Granted, this is not what you asked for, but would it suffice?