hi avadakedava,

Yes, there is a way.

1. Select the column in which the data is present.
2. Select Conditional Formatting.
3. Click New Rule.
4. Select the 5th option "Format only unique or duplicate value
5. In the same window select from drop down "Duplicate"
6. Click on format button
7. Click on Fill Tab and select a color.
8. Click Ok

I tried to attach a screenshot Attachment 149637

You should be good then. :-)


If I was able to help – PLEASE DO NOT FORGET to Click the small star icon at the bottom left of my post.