Skip to main content

Conditional formatting - Highlight Duplicate Values

Conditional formatting - Highlight Duplicate Values

This feature is mostly used to identify duplicate values in a range of cells or array, it also identify the any error of data of unique records like ID numbers, serial numbers etc .

How to do this –
Step 1 - First select the range of cells, then click on Highlight cell rules (conditional formatting) under Home tab

Step 2 - Select rule type as “Duplicate Values”
Step 3 - Then click on OK



Labels:

Comments

Post a Comment

Popular posts from this blog

Report Publishing via Pivot Table in different sheets

Report Publishing via Pivot Table in different sheets This feature is mostly helpful to publish the data in sheet wise Step 1: Create pivot table with Report filter , go to analysis tab or Options tab from "PivotTable options" Step 2: Click on options drop down Step 3: Then click on  “Show report filter pages” Now we can see the new excel sheet tabs names along with data, published based on the report filtered data.
Post a Comment
Read more