Check column "B" if 2 names are same check column "H" if identical URL's color both rows

Check column "B" if 2 names are same check column "H" if identical URL's color both rows
In this case row 1 and 4 needs to be colored
Find-duplicates.xls
LVL 11
bsharathAsked:
Who is Participating?
 
gowflowConnect With a Mentor Commented:
Is this what you want ?
gowflow
Find-duplicates.xls
0
 
gowflowCommented:
Let me understand here.
We need to forget about F and then apply B and H or on top of F and H also check for B ??
gowflow
0
 
bsharathAuthor Commented:
This is total different
here "B" and "H" are only to be checked
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello,

use this conditional formatting formula:

=SUMPRODUCT(--($B$1:$B$4=$B1),--($H$1:$H$4=$H1))>1

see attached. Adjust ranges to suit your data.

cheers, teylyn
Find-duplicates.xls
0
 
gowflowCommented:
Hi Teylyn,
Longtime we did not cross ... how ur doing ? Hope all is well and happy new yr for you and all ur loved ones.

bsharath
basically u hv a choice of either VBA solution or conditional formating. See what suits u
gowflow
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Happy New Year to you, gowflow. I'm on holiday in blazing summer weather in New Zealand.
0
 
gowflowCommented:
wow we hv snow storm here brrrr
gowflow
0
 
bsharathAuthor Commented:
Thank you
0
 
gowflowCommented:
Your welcome anytime.
gowflow
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.