Solved

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

Posted on 2013-01-10
9
246 Views
Last Modified: 2013-01-10
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
0
Comment
Question by:bsharath
  • 5
  • 2
  • 2
9 Comments
 
LVL 29

Expert Comment

by:gowflow
Comment Utility
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
 
LVL 11

Author Comment

by:bsharath
Comment Utility
This is total different
here "B" and "H" are only to be checked
0
 
LVL 50

Assisted Solution

by:teylyn
teylyn earned 250 total points
Comment Utility
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
 
LVL 29

Accepted Solution

by:
gowflow earned 250 total points
Comment Utility
Is this what you want ?
gowflow
Find-duplicates.xls
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 29

Expert Comment

by:gowflow
Comment Utility
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
 
LVL 50

Expert Comment

by:teylyn
Comment Utility
Happy New Year to you, gowflow. I'm on holiday in blazing summer weather in New Zealand.
0
 
LVL 29

Expert Comment

by:gowflow
Comment Utility
wow we hv snow storm here brrrr
gowflow
0
 
LVL 11

Author Comment

by:bsharath
Comment Utility
Thank you
0
 
LVL 29

Expert Comment

by:gowflow
Comment Utility
Your welcome anytime.
gowflow
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now