Conditional formatting if cell is hyperlinked

[dcdimon]

Is it possible to set up conditional formating based on whether the contents of a cell are hyperlinked to something (document, web address..etc)? I have a list of purchase orders where some are linked to an image of the PO and others aren't. The ones that aren't are currently manually shaded a different color and have the text changed to a specific font with a bold format. I'd like to be able to have Excel do this for me based on whether a hyperlink is present. I've searched here and on the web and haven't found anything that specifically addresses this.


Is this possible using either conditional formating or a macro? I'm using Excel 2003. Thanks for any assistance.

 

[Luke M]

this should help get you started

[pre]

Sub HyperlinkMarks()
Application.ScreenUpdating = False
For Each h In ActiveSheet.Hyperlinks
With h.Range
'List everything you want to
'do with the cell

.Interior.ColorIndex = 3 'Color red
End With
Next
Application.ScreenUpdating = True
End Sub

[/pre]

 

[dcdimon]

Thanks, that's exactly what I was looking for, I just wasn't sure where to begin. Thanks a lot!

 

[Luke M]

Sweet, glad we could help.