When you’re using Excel Conditional Formatting, keep an eye out for the ‘Duplicate Rule’ button. Just one of the little mysteries that Insiders have to put up with.įor most Excel 365 users, it’s something to look forward to. Similar to Microsoft Word, you can make document changes such as numbering pages. It’s not the first time this has happened. We finally saw the new Conditional Formatting dialog (image above) in a slightly later version 2012 build 13510.20004 (mid-Nov 2020). To copy only the conditional formatting, move your mouse over Paste Special, then choose Paste Special from the new menu that appears. Right-click anywhere inside the selected area. Drag the mouse to the bottom-right cell in the paste area, then release the mouse button. Yet again there’s a disconnect between what Microsoft says is in an Insiders release and what Insiders get.Īccording to Microsoft, the extra Conditional Formatting features are in Office Insider for Windows versions 2011 Build 13426.20004 at 30 October 2020. How do I copy conditional formatting in Excel Hold down the mouse button. Microsoft will boast about this new feature, but they really should hang their corporate heads in shame.ĭuplicate Rule should have been in Conditional Formatting from the it’s first iteration back in Excel 2007. It’s taken Redmond 13 years to listen to their customers is something that does them no credit at all. Select a rule from the list, click Duplicate Rule and a copy will be added.

Duplicate RuleĪt long, long last, there’s a way to copy an existing rule to be edited for a slightly different need. That means you can show more rules and extend the width to show more details of each rule. The dialog is now resizable from the handle at bottom right.

Conditional formatting in word for mac