How to Highlight Duplicates in Excel makeuseof.com - get the latest breaking news, showbiz & celebrity photos, sport news & rumours, viral videos and top stories from makeuseof.com Daily Mail and Mail on Sunday newspapers.
If you use conditional formatting in Microsoft Excel to automatically format cells that match criteria, you may want to apply the same rule to another part of your sheet or workbook. Instead of creating a new rule, just copy it.
If you use conditional formatting in Microsoft Excel, then you probably know you can use more than one rule at a time. To control those rules as well as edit, delete, or duplicate one, you can use the Rules Manager.