This is to remove or color duplicates rows on google sheet data.
It can find duplicates on single or multiple columns selected.
Generate output data on the same sheet replacing your replacing existing data or populate on a new sheet.
Sort your output data so that all duplicates rows comes together.