Conditional format if hyperlink [Solved/Closed]
Obonden - - Latest reply:
ac3mark
Contributor Last seen
January 22, 2019
- Apr 24, 2017 at 05:08 PM
- Posts
- 11185
- Registration date
- Monday June 3, 2013
- Status
Related:
- Conditional formatting if cell contains hyperlink
- Conditional hyperlink excel - Best answers
- Excel conditional formatting if cell contains specific text ✓ - Forum - Excel
- Conditional formatting multiple cells ✓ - Forum - Excel
- Conditional format range if one cell contains certain text - Forum - Excel
- Conditional formatting merged cells ✓ - Forum - Excel
- Conditional formatting if cell contains text ✓ - Forum - Excel
3 replies
Best answer
Create a function to check if the cell is a hyperlink:
e.g.
=IsHyperLink(A1)
You can use link any of the built-in functions.
Public Function IsHyperlink(aRng As Range) As Boolean
IsHyperlink = CBool(aRng.Hyperlinks.Count)
End Function
e.g.
=IsHyperLink(A1)
You can use link any of the built-in functions.
A few words of thanks would be greatly appreciated. Add comment
4600 users have said thank you to us this month
Hi
Thanks, but I'm not able to set this up:
I really feel like an amateur when I have to ask what operator is used for "contains"? I have browsed for it, but have not been able to find it. According to your suggestion the formula should be like = A1 = "http://", but that expression would only be True when the cell content is exactly like "http://" (and nothing more), as "=" operator means "like", and not "contains"?
Thanks, but I'm not able to set this up:
I really feel like an amateur when I have to ask what operator is used for "contains"? I have browsed for it, but have not been able to find it. According to your suggestion the formula should be like = A1 = "http://", but that expression would only be True when the cell content is exactly like "http://" (and nothing more), as "=" operator means "like", and not "contains"?
- Posts
- 11185
- Registration date
- Monday June 3, 2013
- Status
Did you understand my example? If not, then I am not certain not matter what you have posted, I can explain it right. I DO NOT provide cut and paste solutions, but try to post a very STURDY framework on which to build your solution!
- Posts
- 7
- Registration date
- Saturday March 25, 2017
- Last seen
- April 24, 2017
- Posts
- 11185
- Registration date
- Monday June 3, 2013
- Status
Hi
May be I didn't understand your example, but as written in my comment above I didn't succeed making a "Format only cells that contain"-rule. Of what reason I don't know, but it might be because my cell information is a text (date), and not the hyperlinktext itself.
May be I didn't understand your example, but as written in my comment above I didn't succeed making a "Format only cells that contain"-rule. Of what reason I don't know, but it might be because my cell information is a text (date), and not the hyperlinktext itself.
- Posts
- 11185
- Registration date
- Monday June 3, 2013
- Status
SO, your scope has changed. Your OP says to look and change to a HYPERLINK! If you cannot take my example, and make it work for you, then tell your boss you can't make it work!
This is the #1 reason I will not provide a turn key solution. Once again, if you cannot take my example and apply it to your model, then you are stuck. Maybe someione else will come along and give you the solution, but as far as I am concerned, this is solved with the example I posted!!
Have FUN!
This is the #1 reason I will not provide a turn key solution. Once again, if you cannot take my example and apply it to your model, then you are stuck. Maybe someione else will come along and give you the solution, but as far as I am concerned, this is solved with the example I posted!!
Have FUN!
Hi
You sounds like being angry at me? You shouldn't. I am very glad you made an effort solving my trouble, and I am sorry I didn't explain my problem sufficiently. It seems my problems is solved by using the Public Function defining a IsHyperlink-element. I really do not understand what this code is doing - but doesn't matter for me as long as it works, and I don't need to tell my boss I couldn't solve the problem. I surely have fun :-)
You sounds like being angry at me? You shouldn't. I am very glad you made an effort solving my trouble, and I am sorry I didn't explain my problem sufficiently. It seems my problems is solved by using the Public Function defining a IsHyperlink-element. I really do not understand what this code is doing - but doesn't matter for me as long as it works, and I don't need to tell my boss I couldn't solve the problem. I surely have fun :-)
- Posts
- 11185
- Registration date
- Monday June 3, 2013
- Status
IsHyperlink returns a True or False. It tests whether the text is constructed as a hyperlink. Take my example, and apply it to your model. The word SELECTED in my example, is what I was looking for. So, if you are looking for "How Now Brown Cow", then place that string into your formula. Let me know if that helps!
You can use like any of the built-in functions.
- Posts
- 7
- Registration date
- Saturday March 25, 2017
- Last seen
- April 24, 2017
-