Hey All,

I'm after a formula that will be able to look at all the data in column A and highlight the duplicates e.g. if AAAA229 is listed more than once, each of the values would be highlighted but if it is listed only once, it won't highlight.

Make sense?

Any ideas would be appreciated.