Conditional Formatting for multiple range

I wonder can we make conditional formatting in excel to hightlight certain values in multiple ranges in a couple of certain columns?

so for example all 3 tables in a worksheet, all tables had different row lengths and i want to hightlight automatically 3 largest percentages values in range between "Percentage of Total" and "100,00%" which is the sum of percentages in each tables.

Is there a way to do that?