This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
There used to be an option in the Conditional Formatting Rules Manager to duplicate a rule. I just got an Office update, and now the button is missing. I used this function ALL THE TIME. What happened to it? Can it be added back?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
That does not work. Plus, I need it to remain "Current Selection" as I do not want the rules to apply to the entire worksheet - just to the column that is selected.
I have the same issue using MO Professional Plus 2019, - is there a solution, it is the same whichever view is selected.
That does not work. Plus, I need it to remain "Current Selection" as I do not want the rules to apply to the entire worksheet - just to the column that is selected.
Here is what it looks like now. Between "Delete Rule" and the up arrow, there used to be a "Copy Rule" or "Duplicate Rule" button.
Try changing the drop down from Current Selection to This Worksheet, it should display the rules and the button you're looking for
to confirm my comprehension of your narrative, please provide a screenshot of the setting you are referring to. Thank you.