Excel » Conditional formatting » CF-unique-distinct »

Highlight unique distinct records

The image above demonstrates a Conditional Formatting formula that highlights unique distinct records. This means that the first instance of […]

Highlight unique values in a filtered excel table

Conditional Formatting has some amazing built-in features, for example it lets you highlight unique values in a list without entering a […]

Highlight unique values and unique distinct values in a cell range

The following formula highlights cells that contain unique distinct values, in other words, all duplicate values except the first instance […]

How to highlight unique distinct values

The image above shows conditional formatting highlighting unique distinct values, duplicates are not highlighted. Conditional Formatting Formula: =COUNTIF($B$3:B3, B3)=1 The […]