CF based on duplicate values from more than one column

[drewberts]

I have a sheet with the following columns:-

A B C D
firstname lastname fullname active

Col A & B are manual entry and C joins Col A & B together. Col D is a Yes / No column.

I have CF on Col C to flag any duplicate full names which is easy enough but I want Col C to change colour if there are duplicates in FullName and also Col D. eg:-

Tom Smith Tom Smith Yes
Tom Smith Tom Smith No
Tom Smith Tom Smith Yes

...would result in Col C in Row 1 and Row 3 having Cf applied.

 

[Special-K99]

Select the range you want to highlight

Conditional Formatting
New Rule
Use a formula to determine...

=(COUNTIFS($C$1:$C$3,$C1,$D$1:$D$3,$D1)>1)

Format as required

 

[drewberts]

... as simple as that.

Many thanks, worked a treat