Forum Discussion
jiddar zahid
Nov 12, 2018Copper Contributor
Help with Excel
hi i'm having problems with highlighting duplicates in Microsoft excel , the database that i have has a lot of entries that are duplicates but i'm unable to check them all so kindly if someone can help me with this do let me know how to do it
- JamilBronze Contributor
simply select the range from A4:B4548 and then go to Conditional formatting and highlight duplicates.
see the attached file with the screenshot here.