Comparing cell values in different sheets based on multiple reference values as conditions

Attachment 267115

I have data in two different sheets. The actual data is much much bigger. This is just the sample. So it would be very very painful if I couldn't get a solution to this.

In sheet1, I have the borrowers and outstanding per employee. In the Area Avg sheet, I have the average borrowers and outstanding in each area as this is the standard for comparison (I got this through the subtotal function).

Now what I have to do is in sheet1, format(change the color) each cell under borrowers which is greater than the average of the relevant area. Since, (in my actual data) the name of the area may be duplicate in different regions, the reference value (average borrowers of the area) from "Area Avg" sheet has to be traced through multiple criteria which are: Division, Region and Area. The same also has to be done for outstanding but the solution can be provided for borrowers only.

Any solution that is provided, please let me know if it can be applied to really really huge amount of data.

Thank in advance.

Sample.xlsx