Get Cell Style

  • Thread starter Thread starter Thomas M.
  • Start date Start date
T

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
 
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?
Click to expand...

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.
 
=and(get.cell(22,!b2),get.cell(24+0*now(),!b2)=5)
Click to expand...

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
 
Back
Top