Highlight cells in a column with no hyperlink...

[Dan10]

I have a large list of text in a column from which I would like to highlight those items which do not have a hyperlink.

Is it possible to do this using conditional formatting?

 

[Legacy 143009]

Short answer, no.

You have to create a UDF like below. Create a standard module and paste the code:

Function IsHyperlink(r As Range) As Integer
  IsHyperlink = r.Hyperlinks.Count
End Function

Then you can use UDF like:

=IF(IsHyperlink(A1),"LINK","NO LINK")

 

[Dan10]

Short answer, no.

You have to create a UDF like below. Create a standard module and paste the code:

Function IsHyperlink(r As Range) As Integer
  IsHyperlink = r.Hyperlinks.Count
End Function

Then you can use UDF like:

=IF(IsHyperlink(A1),"LINK","NO LINK")

Thank you.

 

[Dan10]

Short answer, no.

You have to create a UDF like below. Create a standard module and paste the code:

Function IsHyperlink(r As Range) As Integer
  IsHyperlink = r.Hyperlinks.Count
End Function

Then you can use UDF like:

=IF(IsHyperlink(A1),"LINK","NO LINK")

Thank you.

 

[Legacy 143009]

You are welcome