Munkafüzet1 | ||||
---|---|---|---|---|
A | B | |||
1 | www.google.com | IGAZ | ||
Munka1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1 | B1 | =ISREF(A1) |
The formula ISREF is always true no matter what I have in the cell so it does not workHi Robyrux
you can use this (B1) formula in your conditional format
Munkafüzet1
A B 1 www.google.com IGAZ Munka1
Cell Formulas Range Formula B1 B1 =ISREF(A1)
Function ishyplink(target_cell As Range) As Integer
ishyplink = target_cell.Hyperlinks.Count
End Function
asdasd.xlsm | ||||
---|---|---|---|---|
A | B | |||
1 | www.google.com | 1 | ||
2 | something | 0 | ||
Munka1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1:B2 | B1 | =ishyplink(A1) |
Great! It works!Oh, my bad,
morning is painfull :D
Put this into a modul, save the workbook with macro enabled
VBA Code:Function ishyplink(target_cell As Range) As Integer ishyplink = target_cell.Hyperlinks.Count End Function
and you can use this as formula
asdasd.xlsm
A B 1 www.google.com 1 2 something 0 Munka1
Cell Formulas Range Formula B1:B2 B1 =ishyplink(A1)