So basically I'm running a promotion and do a daily ranking. I have over 100 customers and the promotion has 3 seperate categories. The top 10 customers in each category will win, but the customer is only allowed to win once in all 3 categories. So if customer A won in category 1, he/she cannot win in category 2 or 3. So I want to highlight the name and purchases in each category of the "top 10" who haven't already ranked in the top 10 in one of the previous categories. Is there a formula to do this with conditional formatting? I send out an update daily and it''s becoming a pain doing it by hand. Thanks in advance for your replies!