Excel Tricks : VBA Code to find Unique Values in excel | Macro to highlight unique values in excel
To highligh unique values in excel do the following steps using VBA Code.
1. Open active excel sheet
2. Press Alt + F11 and Visual Basic Application window
will open.
3. Go to Insert Menu and select new Module.
4. In new Module insert the below VBA Code and save it.
5. Before do the above process, excel sheet must save as
Macro-Enabled.
6. To do Macro Enabled, open Excel Sheet and Click on the
Office Button which is at left top corner on excel sheet.
7. Select Save as and again select Macro Enabled
Worksheet and then save it.
Sub highlightUniqueValues()
Dim rng As Range
Set rng = Selection
rng.FormatConditions.Delete
Dim uv As UniqueValues
Set uv = rng.FormatConditions.AddUniqueValues
uv.DupeUnique = xlUnique
uv.Interior.Color = vbGreen
End Sub
