Please attach workbook.
Actually the workbook is quite heavy, hence having trouble uploading it..
let me describe the issue:
i have around 1000s of vendors for each category.(12 in number)
I could sort it based on the spend, but i am not able to color code the top 10 on each category.
When i do such thing, the sorting is going for a toss.
What i did was a nested sort, in between Vendor and Category to arive a s sorted level as you can see in the pic.
from there i am stuck.
This worked like magic, thanks a lot for your timely help.
I'm glad that worked. Kindly close the thread by marking my answer as correct so that it may help others who've similar query.