Discover how you can apply formatting features to just those cells within a range that are duplicates or just those cells that are unique.
- [Instructor] You can use conditional formatting…to identify duplicate data, and there certainly…will be times when you do not…want certain entries duplicated.…For example, social security number, that we see…on this worksheet, called duplicate or unique entries.…Now, we could sort that, but this might be a huge list,…and looking through a list like that, trying to find…the duplicates, you know that software should be able…to do that better than we could do it.…So, let's select column B, and then…go to Conditional Formatting on the Home tab,…slide into Highlight Cell Rules,…and you'll see Duplicate Values.…
And immediately, we see a format.…We don't necessarily have to be picky about the display…of the format, we'll simply go with the flow here.…Suggestion looks good enough, and we're seeing…some duplicates already over there, over in rows 13 and 15.…We don't necessarily know whether this was duplicated…one more time, or three more times, so it wouldn't…be a bad idea in here to sort the data.…We could do that pretty quickly here.…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Conditional formatting based on content
- Formatting based on formulas
- Using data bars to display length or volume
- Using color scales to display relative differences
- Highlighting PivotTable results
- Applying banded rows