In pivot match vertical row amount with the horizontal column -amount and highlight that

Hello Friends,

I need your help in preparing a macro which can in pivot match vertical row amount with the horizontal column -amount (vice versa) and highlight that matched amount. The amount will be under the same heading of row heading as well as column heading.

I have attached file and jpg image with this thread for reference.

Thanks in advance.

Hi,

Thanks for welcoming and replying.

Example: In attached file Range A16 has row heading 'UK30', I will match the row data of line#16 with column heading UK30 'Column O' data.
e.g. first value of line#16 is -6727312.4, I will check the positive value(vice versa) in 'column O' of UK30 if amount found as 6727312.4 then macro should highlight that cell with some colour. If not found then it should highlight it with different color or keep it non-colored.

Same way I want to match all the remaining row data with their respective column data.