Forgot some info, once you have imported it (from a new workbook press Alt +
F11, click fileimport and import it), then save as *.xla, then go to
toolsadd-ins and check it. Finally to use it

=EXTCELL("bold",A1)

will return 1 if cell is formatted bold, so with regards to your specifics

=IF(EXTCELL("bold",A1)=1,A1,"")

there are a lot of other functions built in as well, there is no help file
so you need to open the bas file in notepad for instance and print it since
each function has it's own description

Regards,

Peo Sjoblom

"Peo Sjoblom" wrote:

There is no such function built in, Harlan Grove has written extcell which
has that built in (among many other things), it can be downloaded here

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

Then when you have imported it into the VBE you can make it an add-in and
always available


There are probably other add-ins with this functionality to be found online

Regards,

Peo Sjoblom

Regards,

Peo Sjoblom

"Al" wrote:

What is the formula (if statement?) to select a cell based on format. For
example, if the cell is "bold" then I want the contents of that cell.
Otherwise, blank.