You can do the following: on the side of the plate add 2 columns and put this formula there =of browsing(A2;10)
, then allocate 2 received column a Home Tab - Conditional formatting Rule to highlight cells - Duplicate values -customizable colors as you like and press OK. Get the result(see Option1).
Note - the formula will return exactly 10 characters to the right. If the link is longer/shorter than 10 characters will be cut is not correct. And may not highlight the result the same links (in red in the screenshot) when the length of the links less than 10 characters, or Vice versa when the length of the links greater than 10 characters to highlight different links (blue in the screenshot in the link above differs 1 character after the /
More correct to write the formula =prasing(A2;LEN(A2)-SEARCH("/";A2;1))
(assuming that you have a link that is in the format site name/link. (see screenshot Option 2)
Make out the formula from the second option in detail:Pressing
- returns characters from the right edge of a specified length ( the syntax of phrasing("ishex-can be the cell reference";number of characters to return)LEN
(link) - returns the length of the string (number of characters)SEARCH
- returns the number of the desired character in the text (syntax SEARCH("symbol";"cell text"; "the ordinal of the desired symbol"-if you want the 1st 1, if 2nd is 2, etc.)
Therefore if you have links in the format of SITENAME/blah-blah-blah/link in the search instead of 1 put 2.
The second option will highlight the links correctly.
Accordingly also apply conditional formatting as with the first solution. All that is not podsuetilis and there are differences on the links.
If You have links in the format site name/link, and in the format of SITENAME/blah-blah-blah/link write to tell me how to solve this problem.
If something written is not clear is ready to answer questions