While you've almost certainly noticed the distinction between this feature and solution #one is usually that, now, Excel notifies you that a macro continues to be disabled. This is the default choice in Excel and, as described in Excel 2013 VBA and Macros Whenever you halt dragging, the selected spot https://www.customguide.com/excel/excel-conditional-formatting