Share via

FormatConditions.AddUniqueValues Method

  • Article
Excel Developer Reference

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