You can easily highlight the cells containing duplicate values in a column by using a feature called “Conditional formatting”.
This option is available in Home menu. Here is the image showing the way you can use the option.
This was the short and brief demo showing the way to find the duplicate values.
I hope you find this article helpful. After viewing the above short video, you will be able to apply it in your day to day work life such as finding duplicate account number or a cheque number in banking domain.
Please share any further queries or recommendations and feedback with us in the comments section below.