I have a worksheet with data in 50 rows and 6 columns.In 2nd column I am having different locations.I want to color the entire row containing any one or two identical locations.


Thanks!