Conditional Formatting - if there is hyperlink

Hi again everyone,

I've posted this similar question, but it's not on hyperlink.

Anyway, i want to check in a given cell, if I put a hyperlink, i want it to be GREEN in colour, and if i remove the hyperlink, it returns to YELLOW.

Can I do this with UDF, via VBA?

cheers

That code works well - thank you. What would you change if you wanted only the cells containing hyperlinks to change colour while all other cells remained the same?

In Conditional Formatting you can use the Method "IsFormula" to check if a formula is in a cell. Set your formatting as appropriate using that.

In the field you want the Hyperlink, use the "HYPERLINK(link_location, [friendly_name])" formula method instead of the "right mouse click > add Hyperlink" method.

My links all look like this as formulas:

=HYPERLINK("C:\MyFilePath\MyFileName.xlsx", "MyDisplayedLink")

Hello,
This code works very well, but I need to make it for range from B2:B1000 only, any help?

also after each update it selects all the cells, any help on how to disable the selection?

Originally Posted by Moh.zizo

Hello,
This code works very well, but I need to make it for range from B2:B1000 only, any help?

also after each update it selects all the cells, any help on how to disable the selection?

I found the solution if anyone is interested.

Formula:

Please Login or Register  to view this content.