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.
 |
| 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 |
No comments:
Post a Comment