Need help with formula

I am in need of some help deciding which is the correct formula to us as well as how to create iti am looking to highlight duplicate rows of information.  Row1 is all titles:  name (a1), address (b2...