Pivot tables

Hi Hayrican,

Thank you for the forum question.

Please find attached Excel file. In the file you can find different solutions.

You can use Conditional Formatting to highlight if the number match or a number of functions.

If you want to use a function, you may need to turn off the Getpivotdata function.

You can turn this feature off by selecting any cell within an existing PivotTable, then go to the PivotTable Analyze tab > PivotTable > Options > Uncheck the Generate GetPivotData option.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector