http://sqlblog.com/blogs/jamie_thomson/archive/2012/11/02/conditional-formatting-of-duplicate-values-in-excel.aspxOne of the infrequent pleasures of being a data geek like me is that one does occasionally stumble across little-known yet incredibly useful features in a tool that you use day-in, day-out. Today this happened to me and the feature is Excel’s abilityenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/jamie_thomson/archive/2012/11/02/conditional-formatting-of-duplicate-values-in-excel.aspx#45928Sat, 03 Nov 2012 09:54:39 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:45928Michael<p>This feature exists in Excel 2007 and up. </p>