Many times we need to find duplicate values and highlight them with same color in active sheet.
This can not be done by any future of google sheet.
This tool will help you to find duplicate values highlight with same Color within 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 below screenshot:
- After click on Values in Active Sheet it will highlight duplicate row with same color which is yellow and it will show you how many duplicate values have been highlighted in window like below screenshot.
Use of Functionality:
- It will use Highlight Duplicate Values in current tab
Note : It will highlight with Yellow color.