Many times we need to find duplicate values and highlight them with the same color in the active sheet.
This can not be done by any future of google sheet.
This tool will help you to find duplicate values highlighted with the same Color within the active sheet.
CLICK HERE to Install the addon.
How Open Functionality:
- First of all open the Google sheet then go to Extension > Sutra Tools > Highlight Duplicate > Values In Active Sheet like the below screenshot:
- After clicking on Values in Active Sheet, it will highlight the duplicate row with the same color which is yellow and it will show you how many duplicate values have been highlighted in the window like below screenshot.
Use of Functionality:
- It will use Highlight Duplicate Values in the current tab
Note: It will highlight with Yellow color.