Highlight Duplicates in a List

 

 

 

 

HomeOur CompanyContact Us
Business Solutions                                                      Business Intelligence                                                      Business Success
Custom software solutions to fit your business needs.
586-899-5599

 

Browse Services
Database
Web
Server
ERP
eCommerce
Custom Software
Consulting

 

Excel Links
Microsoft Solutions
Resources
Tips
Fun Stuff

Back to Excel Tips Index

1. On the Worksheet Menu Bar go to Format/ Conditional Formatting…

2. Choose “Formula is” in the dropdown box.

3. Type the formula:

                 ex. =COUNTIF(A:A, A1) > 1

4. Click the Format button and choose the Patterns tab.

5. Choose a color and click Ok, and then click Ok again.

Back to Excel Tips Index
 
Send mail to excelchampion@excelchampion.com with questions or comments about this web site.
Copyright © 2008 Excel Champion Consulting