Using a macro to find matching numbers within tables

[lar9149]

Hello all hope every is doing well.

I was wondering if there is a way to create a macro (or formula?) to highlight numbers in tables above it that match the numbers within the specified column and table.

In the sample, in the the table at the bottom (Labeled TABLE in red), I highlighted the numbers in the column heading labeled t11 in red and highlighted in red the numbers that match those numbers in the 3 tables above it (hopefully I didn't miss any).

Is there a macro that would highlight these numbers automatically in the above 3 tables.

Note: the macro would have to be flexible because sometimes I may want to match the numbers in any other column like those in column heading t13 (highlighted blue to differ it from the previous numbers) or any other column in the table.

A second sample (stock comparison 2) has been added to show the tables in different positions and matching a different header (t15)