Get Cell Style

[Thomas M.]

Excel 2007

I need to return a boolean value based on whether or not a cell contains
a hyperlink. All the cells that contain hyperlinks are formatted in the
Hyperlink style.

What formula can I use to tell me if a given cell is formatted in the
Hyperlink style?

--Tom

 

[Héctor Miguel]

hi, Thomas !

Excel 2007

I need to return a boolean value based on whether or not a cell contains a hyperlink.
All the cells that contain hyperlinks are formatted in the Hyperlink style.
What formula can I use to tell me if a given cell is formatted in the Hyperlink style?

let's assume your hyperlinked text is in cell B2 and "the formula" will be (allways) one column to the right (C2)

- select [C2] and add/create/define/... a name using xl4 macro-functions language (i.e.)
name: IsHyperlink
formula: =and(get.cell(22,!b2),get.cell(24+0*now(),!b2)=5)

- apply "the name" to C2 cell: =IsHyperlink

hth,
hector.

 

[Thomas M.]

=and(get.cell(22,!b2),get.cell(24+0*now(),!b2)=5)

That's interesting. I didn't know that was possible. However, I don't
think that it will work in my case. While my original post was merely
looking for a way to determine if a cell contains a hyperlink,
eventually my intent is to incorporate that functionality into a lookup
formula.

In basic terms, I need to lookup the largest value in a range (which I
already know how to do), and then I'll want to determine if the
corresponding column heading is a hyperlink. In all cases the hyperlink
will be the only thing in the column name.

--Tom