Forum Discussion
Excel Conditonal Formatting Duplicate Rules Button has Disappeared
Pretty much title, when I closed and reopened my file, the Duplicate Rules button in the Rules Manager of Conditional Formatting was gone. I have tried to repair the Office apps already, and restarted the app, neither has fixed it. Thanks for any help you can provide.
That explains it - the Duplicate Rule button is available in Excel in Microsoft 365, not in Office 2019.
8 Replies
As an update, I have now uninstalled and reinstalled Office, and checked the file on a different computer. The button is only not there on my computer. Microsoft Support is useless, if anyone has any ideas, please help.
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:
