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
In this case row 1 and 4 needs to be colored
Find-duplicates.xls
ASKER
This is total different
here "B" and "H" are only to be checked
here "B" and "H" are only to be checked
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
Happy New Year to you, gowflow. I'm on holiday in blazing summer weather in New Zealand.
wow we hv snow storm here brrrr
gowflow
gowflow
ASKER
Thank you
Your welcome anytime.
gowflow
gowflow
We need to forget about F and then apply B and H or on top of F and H also check for B ??
gowflow