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 he...
Jamil
Nov 12, 2018Bronze 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.