Highlight unique/duplicates [Conditional formatting]
Excel has a few built-in conditional formatting features, one of them highlights values that have at least one duplicate. The other one highlights unique values meaning there is only one instance of the value in the range.
How to apply conditional formatting
- Select the cell range containing the values.
- Go to tab "Home" on the ribbon if you are not already there.
- Press with left mouse button on "Conditional formatting" button.
- Press with mouse on "Highlight Cells Rules".
- Press with left mouse button on "Duplicate values..."
- A dialog box shows up, here you can choose from duplicate or unique .
- Choose a formatting you want to apply.
- Light red Fill with dark red text
- Yellow fill with dark yellow text
- Green Fill with dark green text
- Light red fill
- Red text
- Red border
- Custom format...
- If you pick "Custom Format..." the following dialog box appears.
- Press with left mouse button on OK button.
- Press with left mouse button on OK button.
The following image shows unique values highlighted.
Highlight cells rules category
Excel has a built-in feature that allows you to highlight dates if a given condition is met. Section 1 below […]
Excel allows you to quickly highlight cells containing a given text string. How to apply Conditional Formatting Select cell range. […]
Excel lets you easily highlight values based on a condition you specify, with a built-in formatting or a custom formatting. […]
Conditional Formatting categories
Excel categories
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.