Is there a function that tells if text in cell is boldfaced?

[keybordrfm]

I inherited a spreadsheet that uses whether or not a cell is boldfaced to
tell the reader something. I need to create mailing labels that only
reference the boldfaced cells. Is that possible? Or should I take the time
to redesign the project?

 

[Ardus Petus]

Use following UDF that will return TRUE if referenced cell is bold:

Function isBold(rCell As Range) As Boolean
isBold = rCell.Font.Bold
End Function

HTH

 

[Franz Verga]

Nel post *keybordrfm* ha scritto:

I inherited a spreadsheet that uses whether or not a cell is
boldfaced to tell the reader something. I need to create mailing
labels that only reference the boldfaced cells. Is that possible?
Or should I take the time to redesign the project?

I think the second should be better...

Till Excel 2003 the function can manage cells' values, not formatting.

Maybe you can succeed with some VBA code, but I can't help that way...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy