Hi,

In the example data below, I have branches, salespeople , sales and refunds
in columns A B Cand D.

I want to conditionally format C & D so that if a Sales Person is in the top
10% of salespeople in their branch, they are highlighted yellow, but
highlighted red if top 10% of salespeople in the whole company.

Example

Branch SalesPerson Sales
Refunds
London Fred 2900
0128
London Agnes 4563
1029
London Mark 4560
1856
London Peter 3167
0462
London Paul 3268
0532
London Glen 4563
0126
London Aaron 2153
0000
London Antony 1567
0292
London Justine 4590
2901
London Richard 0530
6004
London Robert 5310
0029
London Jane 7500
4502
London Angela 3782
0355
London Roberta 7443
0012
London Amy 14543
2023
London Emily 4986
0102
London Phil 4160
0029
Birmingham Jim 1789
0765
Birmingham Joan 21789
0715
Birmingham Graeme 11780
2765
Birmingham Jenny 1765
6507
Birmingham Gerry 2568
0
Birmingham Tony B 7639
1376
Birmingham Gordon 0341
11896
Birmingham David 6285
0375
Birmingham Jimmy 1693
0567
Birmingham Bob 8345
1621
Birmingham Johnny 17891
1076
Birmingham Karl 21784
1721
Birmingham Ken 0028
0

Can any help with this ?

Thanks,

Rich