http://www.contextures.com/xlCondFormat03.html Excel Conditional Formatting Examples Highlight Duplicate Records in a List selectively turn off cells when printing create your own formatting rules http://contextures.com/xlCondFormat03.html#Errors Contextures Excel Conditional Formatting Examples examples of Excel conditional formatting other devious plots Hide or Highlight Duplicates conditional formatting examples http://contextures.com/xlCondFormat03.html#Errors http://www.contextures.com/xlCondFormat03.html#Print