Many times we need to find duplicate rows/values and highlight them with the same color or different color.
This can not be done by any future of google sheet.
This tool will help you to find duplicate rows/values and highlight them with the same or different Colors within the selection or any sheet which you want to choose from the dropdown.
CLICK HERE to Install the addon.
How Open Functionality:
- First of all open the Google sheet then go to Extension > Sutra Tools > Highlight Duplicate > Advance like the below screenshot:
- After clicking on Advance, it Shows below the sidebar window.
Use of Functionality:
- First of all first, you select the Data Type like Rows/values (cells).
- After that select the criteria like Selection/Choose sheet.
- After that select color that you want to highlight with like the same color(yellow)/Highlight Individually(max 50 Colors).
- If you select the ignore case then it will ignore the case.
- Then click on apply button it will highlight duplicate with your data type selection and color selection and it will show you how many values/rows have been highlighted in the window.