I am creating an excel macro. As part of that I need to validate unique composite key in an Excel . ie say Column1 + Column2 + Column3 shouldn't be repeating. 

If so the row should be highlighted in red color.

What is the best way to do it?

Thanks in Advance