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.
No matter how careful you are entering or importing data, duplicates can happen. While you could find and remove duplicates, you may want to review them, not necessarily remove them. We’ll show you how to highlight duplicates in Google Sheets.
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.
Conditional formatting is a terrific feature for automatically applying highlights or font formats to cells. If you have an Excel spreadsheet that contains dates, you can use this feature to make certain dates stand out and easy to spot.