Handy code for conditional formating here: http://superuser.com/questions/484215/setting-background-colour-of-cells-based-on-their-string-length
Find duplicates in data using conditional formating: http://spreadsheets.about.com/od/excelformatting/qt/090516_find_duplicates_in_Excel.htm
