Related:
- Conditional formatting if cell contains hyperlink
- Conditional hyperlink excel - Best answers
- Excel conditional formatting if cell contains specific text - Best answers
- Excel conditional formatting if cell contains specific text ✓ - Forum - Excel
- Excel conditional formatting if cell contains any date - How-To - Excel
- Highlight cell if another cell contains any text ✓ - Forum - Excel
- Conditional formatting merged cells ✓ - Forum - Excel
- Conditional Formating: formula cell text change color ✓ - Forum - Excel
3 replies
Blocked Profile
There is a rule set already built in. Take a look at the below example.
This will look for any text with the word SELECTED in it. Notice the "*".
It's kind of fun to do the impossible! -Walter Elias Disney
This will look for any text with the word SELECTED in it. Notice the "*".
It's kind of fun to do the impossible! -Walter Elias Disney
x
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.
Blocked Profile
Ok, write another rule that checks the value of the cell, not just if there is one. Change the cell text format to change to blue if the text contains a value like: "http://".
Give that a try.
Give that a try.
Obonden
- Posts
- 7
- Registration date
- Saturday March 25, 2017
- Status
- Member
- Last seen
- April 24, 2017
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
-
7
- Registration date
- Saturday March 25, 2017
- Status
- Member
- Last seen
- April 24, 2017
> Blocked ProfileMay 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.
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!
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 :-)