 Hello viewers, welcome to my channel. In this video, we are going to see about automatic highlight of duplicate entry in the column. Select the column which you want to find the duplicate. And right-click on the selected column, then click Conditional Formatting. Then in Format Rules, select Custom Formula Is. And in the below box, enter the formula as equal to count if open bracket and that mention the range of the column which we are going to auto highlight the duplicate. Then select the first cell in the column. In this case, B colon B comma B1. Now close the bracket and enter greater than one. You could also change the color of the highlight in Formatting Style option. By using Fill Color option in that you can find many colors in that you can choose whatever color you want to make highlight. That's it, the formula is set. Now the B column will be automatically highlight for duplicate entry with red color. Thank you for watching this video. If this video is useful, consider to subscribe my channel and don't forget to like and share the video. Thank you.