Formatting Cells with Unique/Duplicate Value

This conditional formatting type is used to format the cells with unique or duplicate value.

To set up formatting for the cells with unique or duplicate value, use the Conditional Formatting group of parameters on the side panel.

Open the Conditional Formatting group of parameters

Select the type of formatted values: unique or duplicate.

Determine the settings on the Settings tab in the Conditional Formatting group of parameters:

Font

Fill

Special border

Special format

Determine the settings on the Advanced tab in the Conditional formatting group of parameters:

Alignment

Other

See also:

Setting Up Conditional Formatting