Explore and use preset rules for conditional formatting Thanks to Microsoft’s preset rules, you don’t necessarily need to create a custom rule from scratch.

In your Excel sheet, go to Home > Conditional Formatting > Manage Rules. Next to Show formatting rules for, click the drop-down menu to select This Worksheet or a specific sheet.

Stay tuned Use Excel’s conditional formatting feature to display a border between data groups. In a future article, I’ll show you how to use a Fill property to distinguish groups.

Identifying duplicate data using conditional formatting One of the easiest ways to locate duplicate data in Excel is to use conditional formatting. Here's how.