Like CELL(), but for text properties?

[Del Cotter]

I have a list in Excel 2000, formatted in the following way

Header1 (Bold, left aligned)
Subhead (indented)
Subhead (indented)
Blank line
Header2 (Bold, left aligned)
Subhead (indented)
etc.

I want to detect a text formatting property of the header cells, in a
similar way to the number and alignment properties available in the
CELL() function, but alignment isn't good enough. Number formatting is
also out, because I want untrained users to use this list, and I need
them to be able to see what they're doing.

Detecting bold-formatted cells would be ideal.

 

[Vasant Nanavati]

Could you be a bit more specific?

 

[Harlan Grove]

I want to detect a text formatting property of the header cells, in a
similar way to the number and alignment properties available in the
CELL() function, but alignment isn't good enough. . . .

....

Unclear exactly what you want, but you could try importing the VBA file
contained in

ftp://members.aol.com/hrlngrv/ExtCell.zip

in the VB Editor, and using the ExtCell function it contains. It works
similar to CELL, but it provides access to most Range class properties.