Wednesday, 19 January 2011

MS- Excel : Highlight Duplicates

Conditional Formatting in Excel is very powerful tool and comes in very handy for data management.

For example , if you have huge data and you would like to highlight duplicate values, it can be done using 2 simple steps. Sort the column for which you want to highlight duplicates
  • Select Conditional Formatting (It is in Home toolbar in Excel 2007) and choose
    Highlight Cells Rules --> Duplicate values and choose the color of your choice

Task accomplished ! Similarly there are other options in Conditional Formatting to highlight 'greater than' or 'less than' etc. ..

No comments:

Post a Comment