I have one base document I have to compare to 15 sheets. I am looking for like pieces of equipment in one main sheet versus the other 15. Specifically I am comparing 1 Column (A) vs another Column (D) in another sheet. I would like the 15 sheets to be highlighted when the duplicate is found. I have tried both formulas and conditional formatting. I am using Windows 7 and Office 2010. Thank you