A few words of thanks would be greatly appreciated. Add comment
5777 users have said thank you to us this month
Public Function IsHyperlink(aRng As Range) As Boolean IsHyperlink = CBool(aRng.Hyperlinks.Count) End Function
A few words of thanks would be greatly appreciated. Add comment
5777 users have said thank you to us this month
DON'T MISS
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.
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 :-)