This rule applies highlighting if the item appears more than once–anywhere. To do so, select B2:C12 and follow the same steps as above. Now let’s use the same built-in rule to compare the list in columns B to the list in column C. Figure B The built-in rules highlights duplicates in the same column. As you can in Figure B, this built-in rule highlighted duplicates in the same column because we selected a single column.įigure A This built-in duplicate rule compares items in a single list.
#4. conditional formatting definition windows 10#
I’m using Excel 2016 (desktop) on a Windows 10 system, but these rules are available in older ribbon versions.
#4. conditional formatting definition how to#
How to create a fun Fly In effect in PowerPoint Get lifetime access to Microsoft Office 2021 for just $50 Next, we’ll use a custom conditional formatting rule to find duplicates when the built-in rule isn’t adequate. First, we’ll apply the built-in duplicates rule to compare items in a single list then we’ll use it to compare two lists. In this article, we’ll use conditional formatting to compare lists and spot duplicates.
![4. conditional formatting definition 4. conditional formatting definition](https://www.w3schools.com/EXCEL/img_excel_db_menu.png)
You must know your data and apply an appropriate solution. You’ll find many solutions if you search the internet, but you’ll find no one-size-fits-all solution. Then there’s the definition of duplicate.
![4. conditional formatting definition 4. conditional formatting definition](https://i.ytimg.com/vi/nfP3uFyNl-Y/maxresdefault.jpg)
You can compare values in the same list or you might want to compare one list to another. Whether you're comparing a single list or several, Excel's conditional formatting can get the job done.Ĭomparing lists for common values, or duplicates is a task that often has many variables. How to use Excel’s conditional formatting to compare lists