highlight names that appears in column 2 and 3 but not 1

INN

Board Regular
Joined
Feb 3, 2021
Messages
118
Office Version
  1. 365
Platform
  1. Windows
Hi
I have 3 columns. I want to highlight names that appears in column 2 and column 3 but not appeared in column 1. In this table, I want to highlight "David" because the name appears in column 2 and 3. How can I do that? Thank you very much.

Name1Name2Name3
MaryMaryMary
AlexAlexAlex
SamSamSam
AnnaDavidDavid
AnnaAnna
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
How about
Fluff.xlsm
ABC
1Name1Name2Name3
2MaryMaryMary
3AlexAlexAlex
4SamSamSam
5AnnaDavidDavid
6AnnaAnna
7
Data
Cells with Conditional Formatting
CellConditionCell FormatStop If True
C2:C10Expression=AND(COUNTIFS(A:A,C2)=0,COUNTIFS(B:B,C2))textNO
B2:B10Expression=AND(COUNTIFS(A:A,B2)=0,COUNTIFS(C:C,B2))textNO
 
  • Like
Reactions: INN
Upvote 2
Solution
Thank you very much. Appreciate the help.
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,215,459
Messages
6,124,945
Members
449,198
Latest member
MhammadishaqKhan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top