Hi, I have a column containing several thousand VAT numbers and I want to highlight the duplicates. I have tried conditional formatting, but that picks up all those that are TBC or Not Registered, which I don't want highlighted. I can't see how to exclude text (or include numerical values only). I would be grateful for some help on this. Thank you.