When a conditional formatting rule is overkill, use these VBA procedures to highlight duplicates and then remove the highlighting in Microsoft Excel.

Excel's format painter doesn't just work with cell formatting—you can also duplicate formatting between shapes, charts, text boxes, and most other items in your spreadsheet.