FormatConditions.AddUniqueValues Method (Excel)

Returns a new UniqueValues object representing a conditional formatting rule for the specified range.

Version Information

Version Added: Excel 2007

Syntax

expression .AddUniqueValues

expression A variable that represents a FormatConditions object.

Return Value

UniqueValues object

Remarks

You can use the UniqueValues object to quickly visualize cells that contain either unique or duplicate values.

See Also

Concepts

FormatConditions Object Members

FormatConditions Object