Forum Discussion
Excel Conditonal Formatting Duplicate Rules Button has Disappeared
That explains it - the Duplicate Rule button is available in Excel in Microsoft 365, not in Office 2019.
Sorry, I don't have a solution, but I just wanted to add that I have the same problem.
I am a new user of Excel2019 having only just migrated from Excel2003, so it's not that I've lost the Duplicate Rules button, it's just not there in my copy of Excel2019.
When you create a rule, you should find it in Conditional Formatting > Highlight Cells Rules > Duplicate Values...
When you edit an existing rule:
I may have misunderstood you, but you seem to be referring to "Duplicate Values" rather than "Duplicate Rule".
I did try what you showed (I think), but it highlighted the wrong cells in a different format than (ie. not duplicating) an existing rule I had created.
Sorry about that.
Which version of Office/Excel are you on, and which platform? (Windows, Mac, online, ...)
- Office 2019 on Windows 10