#328 Use Conditional Formatting to Find Duplicate Values

Excel 2010‘s conditional formatting feature is a super quick and easy way to find duplicate data in your spreadsheets.

Before-After

How It Works

  1. Select a range of cells, table, or PivotTable report.
  2. From the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then go to Highlight Cells Rules » Duplicate Values

ConditionalFormatting

  1. Choose the formatting you’d like to apply to the duplicate values and click OK.

DialogBox

Advertisements

2 thoughts on “#328 Use Conditional Formatting to Find Duplicate Values

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s