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.
Click "Conditional formatting" button.
Click on "Highlight Cells Rules".
Click "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.
Click OK button.
Click OK button.

The following image shows unique values highlighted.

Highlight cells equal to

Excel lets you easily highlight values based on a condition you specify, with a built-in formatting or a custom formatting. […]

Highlight cells containing string [Conditional formatting]

Excel allows you to quickly highlight cells containing a given text string. How to apply Conditional Formatting Select cell range. […]

Highlight a date occuring [Conditional formatting]

Excel has a built-in feature that allows you to highlight dates if a given condition is met.The date conditions you […]

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.

Contact Oscar

You can contact me through this contact form