I have a subtotaled list of customer's business by brand and I want to apply conditional formatting, or ranking to highlight the top ten customers by brand. For example:

Col G Lists the customer name
Col H lists the 5 different brands (customer name in G repeats)
Col I lists the dollar volume per brand

I want to highlight the top ten customers for brand A, brand B, brand C etc.

Applying conditional formatting to only visible cells could get me there, but I am not having any luck. Any other ideas?

I am open to adding a column to note the rank, or highlight the cells.