Aug 13 2018 01:51 PM
Hi, when i attach a hyperlink to a cell, i want it to auto change colour. I have used Conditional Formatting for "No Blank", but this works with any text - i want the cell to only format when a Hyperlink is attached to it. I would really appreciate some help.
Thanks in advance all.
Aug 14 2018 12:13 AM
In your workbook create a VBA module. Add the following code to it:
Function IsHyperlink(Cell As Range) As Boolean
If Cell.Hyperlinks.Count > 0 Then
IsHyperlink = True
Else: IsHyperlink = False
End If
End Function
Use this IsHyperlink function in your Conditional Formatting
Aug 14 2018 12:32 AM
SolutionA hyperlink has a format, in the same way that headings are formats. Assuming you're using a version with a ribbon; start from your hyperlinked cell, click the Home ribbon tab, then cell styles. In the second section, "Data and Model," you will see the Hyperlink style. Right-click on it, and you can edit the style to be as you want.
Aug 28 2018 02:40 PM
Aug 14 2018 12:32 AM
SolutionA hyperlink has a format, in the same way that headings are formats. Assuming you're using a version with a ribbon; start from your hyperlinked cell, click the Home ribbon tab, then cell styles. In the second section, "Data and Model," you will see the Hyperlink style. Right-click on it, and you can edit the style to be as you want.