In the resulting dialog, select an appropriate format and click OK.Choose Highlight Cells Rules and then select Duplicates Values in the subsequent menu ( Figure A).On the Home tab, click Conditional Formatting in the Styles group.To illustrate, we’ll first look at how the built-in rule compares items in a single list, using the simple sheet shown in Figure A as follows: You’ll need no specialized knowledge, but you should understand how the feature works to avoid frustration. You can use a formula with conditional formatting to compare data, but sometimes the built-in rules can get the job done. You can’t however, apply custom rules in the browser. The browser edition supports existing conditional formatting rules and you can even apply built-in rules. You can work with your own data or download the demonstration. I’m using Excel 2016 (desktop) on a Windows 10 system, but these rules are available in older ribbon versions.
#CONDITIONAL FORMATTING EXCEL 2016 BASED ON CELL TEXT 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.
![conditional formatting excel 2016 based on cell text conditional formatting excel 2016 based on cell text](https://www.exceltip.com/wp-content/uploads/2019/11/00411.png)
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. 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.
![conditional formatting excel 2016 based on cell text conditional formatting excel 2016 based on cell text](https://www.exceltip.com/wp-content/uploads/2014/08/IF-2.png)
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