What is the duplicates formula in Excel?

What is duplicates Conditional formatting in Excel?

In Conditional Formatting “Duplicate Value” is a function which highlights those cells' value that contains the same value or text two or more than two times in a row or column. And another function is it can also highlight unique value from the selected cell range.

Please follow the below images for better understanding.

Click on conditional formatting > Highlight cell rules > Duplicate Value.

what is the formula to highlight duplicates value in excel

To highlight duplicate value or any text from the selected cell Click on Duplicate or if you want to highlight a Unique value or text you can choose other Unique options. Kindly note that first select the area from where you want to highlight the values.

excel conditional formatting formula to find duplicate values