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.