Can someone assist me with highlighting rows that are duplicated on a spread sheet? It will validate one column and if the contents are dulplicated then the entire row A - E should be highlighted. I searched for a solution for this but most people are suggesting conditional formatting, i dont want to use that based on how I want the program to function.