URL Comparison & Marking

[p225588]

Please help me out with this. I want to do this in Excel.

Actually I want to compare different URLs which will be present in two different columns in an excel sheet.
If the URL(domain name) is same in that particular cell(in both the column) should get highlighted with some color.

As shown in 1st picture column C and column D contains different URLs. The form of URL in column ‘C’ will always be like i.e. http://bikeadvice.in/ or http://www.bikeadvice.in/
But in column ‘D’ it may not be exact domain name, but may be some inner pages of that domain like
http://bikeadvice.in/bikers-guide/ or some totally different domain

I want to compare these 2 columns and highlight the cell which are having entries of same domain name.
Please refer to picture 2.


Please tell how I can do this by using formula/macro or something else in Excel.

[p225588]

Please tell if the above is possible in excel or not and if yes then what are the steps???

[NBVC]

Next time please post actual workbook so we can test without having to recreate....

Select C2:C16 and go to Home|Condititional Format|New Rule

Select Use a formula to determine which cells to format from top

and enter formula:

=SEARCH($D$3:$D$12,C2)

click format and choose from Fill tab.

Click Ok. Click Ok to exit and apply.

Select now D3:D12 and repeat above with formula:

=SEARCH($C$2:$C$16,D3)