Highlight Unique Values

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,805
Office Version
  1. 2016
Platform
  1. Windows
Hi
I am trying to understand the code below but I am having difficult time to understand these lines and what they do
Code:
rng.FormatConditions.Delete
Code:
Set uv = rng.FormatConditions.AddUniqueValues
Code:
uv.DupeUnique = xlUnique

Thank you very much.

Code:
Sub find_unique()
    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

souce https://excelchamps.com/blog/useful-macro-codes-for-vba-newcomers/
 
Last edited:

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
These lines are removing and adding Conditional Formatting via VBA.

rng.FormatConditions.Delete

is roughly the equivalent of clicking Conditional Formatting > Clear Rules > Clear Rules from selected cells.


Set uv = rng.FormatConditions.AddUniqueValues

is derived from clicking Conditional Formatting > Highlight Cells Rules > More Rules > Format only duplicate or unique values. You can use the macro recorder to see this. The lines from the macro recorder don't match that macro exactly, the macro author selected the parts he wanted.
 
Upvote 0

Forum statistics

Threads
1,213,495
Messages
6,113,992
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top