![conditional formatting excel 2016 duplicates conditional formatting excel 2016 duplicates](https://www.exceltip.com/wp-content/uploads/2014/08/IF-2.png)
![conditional formatting excel 2016 duplicates conditional formatting excel 2016 duplicates](http://www.iwillteachyouexcel.com/wp-content/uploads/2016/07/24-Duplicates-Conditional-Formatting.gif)
We have data of various product id, product name, and its selling price.
#Conditional formatting excel 2016 duplicates how to#
In this article we will learn how to use this “Format Only Unique Or Duplicates Values”.
![conditional formatting excel 2016 duplicates conditional formatting excel 2016 duplicates](https://www.lifewire.com/thmb/MciXFPZqDaomJSBiV_C2Z3Elt08=/1188x891/smart/filters:no_upscale()/ExcelConditionalFormatting-5c572f3f46e0fb0001820a47.jpg)
In order to find duplicates and unique value, Excel has special function of format only unique or duplicates values under conditional formatting. While working on big data we come across many duplicates in the working data which may create confusion. The conditions can be, based on the selected cell’s contents, or based on the contents of another cell.Ĭonditional formatting was introduced in the year 2007. Here you can create a new rule/condition for the cell. Conditional formatting will not return the condition if the cell is blank. In conditional formatting, you have to select a cell or range of cells to apply the format. ⦁ The formatting will be applied if the condition or rules that we supplied are met. ⦁ Border color and border style (but not border thickness) But conditional formatting does not have the option of changing the size of the font. One can apply the following formats using conditional formatting The important function is to grab the attention of the users to the most important data in that spreadsheet. Conditional formatting highlighting the data using colors and icons to cell or range of cells. The foremost function of conditional formatting is to present huge data in an understandable manner. Conditional formatting is a tool useful in presenting data to the users in an Excel spreadsheet in a unique way.