We show you how to highlight duplicates in Google Sheets using the COUNTIF and ARRAYFORMULA functions under the conditional format rules.

What is conditional formatting in Excel? Conditional formatting is a feature used to make unique, important, or duplicate values stand out or to emphasize trends in a data set.

If you want duplicate values to stand out in an Excel spreadsheet, you can choose between two conditional formatting rules.

Next, we’ll use a custom conditional formatting rule to find duplicates when the built-in rule isn’t adequate. I’m using Excel 2016 (desktop) on a Windows 10 system, but these rules are ...

Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. Learn the basics of this amazing feature.

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.

Set Up Conditional Formatting in Outlook As of this writing, the conditional formatting feature is only available in the Windows version of Microsoft Outlook. To get started, open Outlook and follow ...