View Single Post
  #1   Report Post  
frankjh19701 frankjh19701 is offline
Member
 
Posts: 89
Post Finding Duplicate Rows & Highlighting them

I have data in a worksheet that contains both numbers & text.

I want to find a formula or Macro that can search the entire sheet and ONLY highlight the rows that are duplicated. Not just the first cell, the whole row.

The data goes from Column A to Column M.

I don't want them deleted or moved - only highlighted.

Any/all assistance would be greatly appreciated.

Thank you