CF based on duplicate values from more than one column

drewberts

Board Regular
Joined
Sep 5, 2013
Messages
156
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.
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,342
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
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,099,699
Messages
5,470,250
Members
406,686
Latest member
BNR_ 1980

This Week's Hot Topics

Top